Microsoft ACE OLEDB provider throws could not find installable ISAM exception

Question

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?

Answer 1

I came into the same problem today. My configuration is:

• x64 .NET 2.0 Desktop Application which reads an XLSX file.
• x64 version of Microsoft Access Database Engine 2010 Redistributable
• My connection string included the Extended Properties attribute with the value "Excel 14.0;", as the documentation from the component reads.

I had exactly the same problem you have: Could not find installable ISAM exception. I solved it after I came across this article which states that there's a bug on the component's documentation of MS' site. I'm not sure if the component's documentation is inaccurate, what I can say is that changing Extended Properties to Excel 12.0 Xml solved the problem.