Hi,
now I don't get an error, but nothing is in the dataset. Here's my code:
string strWorkbookName = Globals.ThisWorkbook.FullName;
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strWorkbookName + ";Extended Properties='Excel 12.0;HDR=Yes'";
OleDbConnection xlConn = new OleDbConnection(strConn);
string strExcelSheet = Globals.Tabelle1.Name;
Properties='Excel 8.0;HDR=Yes;IMEX=1'";
OleDbDataAdapter xlDA = new OleDbDataAdapter("Select * from [" + strExcelSheet + "$] ", xlConn);
xlDA.Fill(dsDataLoad, "dtDLD");
MessageBox.Show(dtDLD.Rows[7]["colSAPCode"].ToString());
dataGridView1.DataSource = dtDLD;
Anyone knows what's wrong here
Thanks Chris