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

Filed under:
|
|

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

Related posts about excel

Related posts about oledb