Could not find installable ISAM

[Tommy Malone]

Using William Ryan's articles as a guide (excellent help, is William) I am
trying to connect to my Excel data source. However, I am running into a
"Could not find installable ISAM." error message trying to connect to the
datasource. Does anyone have any tips as to how this is overcome?

Thanks!

 

[Tommy Malone]

This is my current connect string:

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=" + ExcelFile +
";ExtendedProperties=Excel 8.0;"

 

[Tommy Malone]

Fixed it. The problem was in my "" in my connection string.