Microsoft ACE OLEDB provider throws could not find installable ISAM exception
- by Michael Stoll
I'm trying to read Excel spreadsheets with a 64bit Process. Therefore I use the 64 bit Version of Micorosft Access Database Engine 2010.
The following code
var cs = @"Provider=Microsoft.ACE.OLEDB.12.0;"
+ @"Data Source=C:\test.xls;"
+ @"Extended Properties=""Excel 14.0;""");
con = new OleDbConnection(cs);
con.Open();
throw an Exception:
Could not find installable ISAM
Using google I found a lot of questions about this exception. But they refer to JET and seem not apply to my problem.
Any recommendations?
