Microsoft ACE OLEDB provider throws could not find installable ISAM exception
Posted
by
Michael Stoll
on Stack Overflow
See other posts from Stack Overflow
or by Michael Stoll
Published on 2010-08-20T13:50:16Z
Indexed on
2012/09/17
15:38 UTC
Read the original article
Hit count: 429
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?
© Stack Overflow or respective owner