Could not find installable ISAM

I had the same error, but none of the suggestions above worked. In my case all I had to do was to change my 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;'). Once I added those single quotes the error disappeared!


There's no 64 bit version of the Jet OLEDB drivers, so if you are running this on a 64 bit OS you might need to target x86 in your .NET application and not Any CPU:

alt text


I was getting this issue trying to opening an xls file with a more recent provider. I fixed this issue by changing my extended properties from

Extended Properties="Excel 11.0;"

to

Extended Properties="Excel 8.0;"

I guess Excel 11 expects an xlsx style file.

Tags:

C#

Oledb