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 ?

possible duplicate of [System.Data.OleDb.OleDbException: Could not find installable ISAM](http://stackoverflow.com/questions/11562267/system-data-oledb-oledbexception-could-not-find-installable-isam) — bummi, Jul 05 '15 at 07:30

score 22 · Answer 1 · answered Feb 06 '15 at 17:08

22

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!

answered Feb 06 '15 at 17:08

DigiOz Multimedia

1,156
1
12
28

This worked for me by putting all extended properties into the quotes '' – bic Sep 25 '20 at 17:47

score 4 · Accepted Answer · answered Nov 18 '10 at 12:07

4

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

answered Nov 18 '10 at 12:07

Darin Dimitrov

1,023,142
271
3,287
2,928

3

I fixed this issue by putting quotes around the data source. See answer here: http://stackoverflow.com/questions/512143/error-could-not-find-installable-isam/512187#512187 – Charlino Oct 15 '11 at 05:57
I had the same error, and [this](http://stackoverflow.com/a/18307822/426315) is how I've fixed it – itsho Aug 21 '13 at 06:57
This did not fix my problem as well. – Aditya Bokade Mar 30 '14 at 03:32
did not fix mine too – levi Jul 01 '16 at 09:17

score 3 · Answer 3 · answered Jun 05 '14 at 05:10

3

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.

answered Jun 05 '14 at 05:10

squig

755
7
18

Wow I was using Microsoft.ACE.OLEDB.16.0 and I changed Excel 160 to 8.0 and worked fine Thanks. – AbbathCL Mar 28 '21 at 04:01

score 1 · Answer 4 · answered Mar 16 '18 at 11:24

On 64-bit Windows and 64-bit Office (2010, 2013) environments, there are many reports on this error. The fix or workaround is a bit strange but seems to work for most people out there.

The "Microsoft Access Database Engine 2010 Redistributable" installation package seems the natural one to use but several reports says it does not work.

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

score 0 · Answer 5 · edited Jun 09 '15 at 06:27

0

use Extended properties="\excel 8.0;

edited Jun 09 '15 at 06:27

Dyrandz Famador

4,499
5
25
40

answered Feb 13 '15 at 07:45

ASKA

21
1
6

score 0 · Answer 6 · answered Jun 19 '20 at 05:52

I had the same kind of problem. I was using an Excel 2010 database. But I had a xlsx file instead of xls. I solved my problem using the connection string as fallows,

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=logbook.xlsx;Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';

What I was missing are, I used OLEDB.4.0 instead of ACE.12.0 . I tried using ACE.14.0. But it didn't work either. Then I missed inverted commas ( ' ' ) around Extended Properties.

Sorry if the answer is hard to read, I am uploading this in my phone.

score 0 · Answer 7 · answered Sep 29 '20 at 12:54

// SET A CONNECTION WITH THE EXCEL FILE.

              OleDbConnection myExcelConn = new OleDbConnection
                  ("Provider=Microsoft.ACE.OLEDB.12.0; " +
                      "Data Source=" + Server.MapPath(".") + "\\" + fileUpload1.FileName +
                      ";Extended Properties='Excel 12.0;HDR=YES'");

Putting Single quote in Extended Properties like Extended Properties ='Excel 12.0:HDR=YES' solved my problem.

Could not find installable ISAM

7 Answers7

Linked