I have used ExcelDataReader to read sheets from excel and converted to a dataset using the AsDataset method.
I have all the sheets as datatable. When i read the 4th sheet (DataTable), it actually reads another sheet..
I have sheets
1 Org Structure
2 Account Codes
4 User Access
5 Financial Data
6 Budget Input Sheets
I have all these sheets as a Datatable... Whne i refer Dataset.Tables, it actually takes data from sheet 6 Budget Input Sheets
The excel sheets were once moved back and forth...
Could anyone sugges what might be the issue?
I am also having the same issue, has there been a solution to this issue? I thought maybe that the sheet order in the VBA Project might have something to do with it, but they don't line up with the dataset.table order either.
Any ideas anyone?