none
Could not find installable ISAM. RRS feed

  • Question

  • Hi,

       I am trying to read the excel file using c#. I am getting the "Could not find installable ISAM." Error.

    I have checked the registry of Jet 4.0 - Excel pointing to c:\windows\system32\msexcl40.dll

    My connection string is

    string xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ImportInventory/OpeningStock_FP.xls") + ";Extended Properties=Excel 8.0;IMEX=1;HDR=NO";

    Any one can you help me?



     

     

    Thursday, September 9, 2010 12:53 PM

Answers

  • I would suspect a bad connection string format. You need to make certain the syntax is correct for the Extended Properties. Below is an example for C# (note the extra set of double quotes):

    string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
      Data Source=Book1.xls;Extended Properties=
      ""Excel 8.0;HDR=YES;""";
    

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Proposed as answer by goodwillwins Tuesday, September 14, 2010 6:25 AM
    • Marked as answer by liurong luo Wednesday, September 15, 2010 11:31 AM
    Thursday, September 9, 2010 6:29 PM