Could not find installable ISAM

  • Thread starter Thread starter Cdude
  • Start date Start date
C

Cdude

I am you this connection string

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testsheet.xls;Extended
Properties=Excel 8.0;HDR=YES

I get this error.I have registered the ISAM dll

Could not find installable ISAM
 
I am you this connection string

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testsheet.xls;Extended
Properties=Excel 8.0;HDR=YES

I get this error.I have registered the ISAM dll

 Could not find installable ISAM
Click to expand...

Hi Cdude,

Use this:
sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
FilePath +
";Extended Properties=" + (char)34 + "Excel
12.0;HDR=YES;" + (char)34;
Hope it would help you.

Thank you,
Venu
 
9 times ouf of 10 .. it is an issue with the syntax/spelling/spacing of
your connection string.

As the previous poster suggested, try his and it that does not work

ANALLY GO THROUGH/OVER YOUR CONNECTION STRING.
Every space , semicolon, etc.
 
Back
Top