Fixed: Error Could not find installable ISAM when use IMEX

How to fix the error "Could not find installable ISAM" when using property IMEX. Recently I have to upload an Excel file into a datatable using ASP.NET. I then encounter the error. After spending many hours I finally figure out what was wrong with it, and it is a really simple fix. It all has something to do with the connectionstring.

Here is my original string that I get the error:

string conn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0; HRD=Yes;IMEX=1;", file);
 
CORRECTION - This one will work:
 
string conn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";", file);
 
If you are using multiple properties for the Extended Properties then it need to be enlosed in a double quote. So put \" to make sure it has the double quote around.
 
Did you like this tip? 
 
Hopefully this will help you.

Comments (4)

|196.12.58.xxx |2011-04-07 09:01:27 Anil kumar - Fixed: Error Could not find installable ISAM when

I Goggled for the ISAM problem half of the day. Finally the got the solution and it as simple as placing Extended Properties in between . double quotation mark
Ex: Extended Properties= \"Excel 8.0;HDR=Yes;IMEX=1 \"

Connection string: "Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties= \"Excel 8.0;HDR=Yes;IMEX=1\";"

|98.231.17.xxx |2011-05-01 15:47:06 Maruthi

It worked for me. Thanks!!!.

|203.123.141.xxx |2011-12-21 11:22:31 sageer - i am using this source but i am geeting ISAM error

Dim cn As New System.Data.OleDb.OleDbConnection
Dim cmd As New System.Data.OleDb.OleDbDataAdapter
Dim ds As New System.Data.DataSet()
cn = New System.Data.OleDb.OleDbConnection("provider=Microsoft.jet.oledb.4. 0;datasource=C:\MyProject\Registration2003.mdb; Extended Properties= Access 2007")

cmd = New System.Data.OleDb.OleDbDataAdapter("select * from [table1]", cn)

cn.Open()
cmd.Fill(ds, "Table1")
cn.Close()

Dim dv As New Data.DataView
dv = ds.Tables("table1").DefaultView
Me.GridView1.DataSource = dv
DataBind()

|114.143.166.xxx |2012-03-26 10:31:44 sumit - Good Job

Anil kumar,

Thank you very much...Good Job

< Prev		Next >