I am trying to read Excel file in VB.NET with the following provider
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\Bok1.xlsx;Extended Properties=""Excel 8.0;HDR=YES;""
But the problem is - with this provider I can read an .xlsx file when it is opened in Office Excel Application but when i close
the application i cant read the file and get the following exception on connection invoke.
The external table has a different format than expected.
View Complete Post