I am writing a C# windows program and I need to load an Excel sheet into a DataTable. This is not a problem, and I do it like this:
OleDbDataAdapter MyDA = new OleDbDataAdapter("select * from [" + "ark1" + "$]", @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtExcelDatabaseFile.Text + ";Extended Properties=\"Excel 8.0;Persist Security Info=False;HDR=NoIMEX=1;\"");
catch (OleDbException oe)
This works fine. My problem is that the data that I have now is split into two execl sheets.
Is there a way to append data from the second Excel sheet to the dt_Database DataTable after filling it with data from the first Excel sheet??
Thanks in advance