Could not find installable ISAM

Question

I have the following code:

string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\db\suc.xls; Extended Properties=""Excel 12.0;HDR=YES;"""; // Create Connection to Excel Workbook using (OleDbConnection connection = new OleDbConnection(excelConnectionString)) { OleDbCommand command = new OleDbCommand ("Select * FROM [Sheet1$]", connection); connection.Open(); 

and I get the following error:

Could not find installable ISAM.

at connection.Open() . Any ideas?

Answer 1

There is no 64-bit version of Jet OLEDB drivers, so if you use this on a 64-bit OS, you may need to configure x86 in your .NET application, not Any CPU :

Answer 2

I had the same error, but none of the above suggestions worked. In my case, all I had to do was change the connection string to this:

 string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties='Excel 12.0;IMEX=1;'"; 

Note the single quote around the Extended Properties attribute ("Excel 12.0; IMEX = 1;"). As soon as I added these single quotes, the error went away!

Answer 3

I get this problem when trying to open an xls file with a later provider. I fixed this problem by changing my advanced properties from

 Extended Properties="Excel 11.0;" 

to

 Extended Properties="Excel 8.0;" 

I assume Excel 11 expects an xlsx style file.

Answer 4

use Extended properties="\excel 8.0;

Answer 5

In 64-bit Windows and 64-bit Office environments (2010, 2013), there are many reports of this error. A fix or workaround is a bit odd, but seems to work for most people.

The " Microsoft Access Database Engine 2010 Redistributable " installation package seems natural, but several reports say that it does not work.

Instead, using the " " 2007 Office System Driver: Data Connectivity Components "seems to solve the above problem for most people.