App cannot read Excel file it created.
Posted on 2011-03-17
I have a VB.NET app that creates an Excel file via Interop process. The file appears fine and opens in Excel with no problem. But if I attempt to import the same file into a datatable via OleDbDataAdapter, it throws the error: "External table not in the expected format."
If I attempt to import an Excel file that was not created by the app, it imports (loads the datatable) fine.
Again, the exported file that I am attempting to import loads fine in Excel with no problem.