Ошибка could not find installable isam

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 ?

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.

answered Jun 19, 2020 at 5:52

// 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.

answered Sep 29, 2020 at 12:54

Изучите преимущества подписки, просмотрите учебные курсы, узнайте, как защитить свое устройство и т. д.

В сообществах можно задавать вопросы и отвечать на них, отправлять отзывы и консультироваться с экспертами разных профилей.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

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 ?

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.

answered Jun 19, 2020 at 5:52

// 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.

answered Sep 29, 2020 at 12:54

asked Feb 4, 2009 at 16:32

Just use Jet OLEDB: in your connection string.
it solved for me.

an example is below:

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=E:\Database.mdb;Jet OLEDB:Database Password=b10w"

answered Apr 8, 2013 at 12:25

I have just encountered a very similar problem.

Like you, my connection string appeared correct—and indeed, exactly the same connection string was working in other scenarios.

The problem turned out to be a lack of resources. 19 times out of 20, I would see the «Could not find installable ISAM,» but once or twice (without any code changes at all), it would yield «Out of memory» instead.

Rebooting the machine «solved» the problem (for now…?). This happened using Jet version 4.0.9505.0 on Windows XP.

answered Oct 13, 2009 at 22:12

I used this to update a excel 12 xlsx file

        System.Data.OleDb.OleDbConnection MyConnection;
        System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
        MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0;Data Source='D:\\Programming\\Spreadsheet-Current.xlsx';Extended Properties='Excel 12.0;HDR=YES;';");
        MyConnection.Open();
        myCommand.Connection = MyConnection;
        string sql = "Update [ArticlesV2$] set [ID]='Test' where [ActualPageId]=114";// 
        myCommand.CommandText = sql;
        myCommand.ExecuteNonQuery();
        MyConnection.Close();

answered Nov 25, 2015 at 21:32

Use the connection string below to read from an XLSX file:

string ConnectionString = «Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=» + <> + «;Extended
Properties=Excel 8.0;»;