Excel Sheet needs to be open to read through oleDb with c#?

68 views Asked by At

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.

0

There are 0 answers