Could not find installable ISAM

[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

 

[Venu]

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

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

 

[sloan]

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.