Could not find installable ISAM.


Posted on July 6th, 2015 by Hitesh Kumar | 421 Views

This type of error occur when we use “IMEX=1” in the connection string of excel file.

String strConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelPath + FileName + ";Extended Properties=Excel 12.0;Persist Security Info=False;IMEX=1;ImportMixedTypes=Text";


To Avoid this error. We have to use Single Quotes in the Extended Properties.

String strConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelPath + FileName + ";Extended Properties='Excel 12.0;Persist Security Info=False;IMEX=1;ImportMixedTypes=Text'";

Related posts:

  1. How to read mixed data type values from Excel in Asp.net?
  2. How to convert excel to pdf in C#.
  3. Export datatable to CSV (Comma Separated Values) in Asp.net.
  4. Export Gridview to Excel in Asp.Net.