0

I've got this big bad program all written up and everything works. But when i read in the excel sheet using oledb and c#, for some reason, the sheet cannot load unless the sheet is open in excel.

The error I get is:

System.Data.OleDbException (0x80004005): External table is not in the expected format

But it works just fine if the file is open in excel when i run the c# app. Weird. Don't whats going on.

Soner Gönül
  • 97,193
  • 102
  • 206
  • 364
Alecks
  • 129
  • 1
  • 7
  • this has been answered http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format basically you need a different connection string. – Joshua Jun 12 '15 at 15:04
  • http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format This fixed my problem real quick like – Alecks Jun 12 '15 at 17:38

0 Answers0