ERROR HELP:COULD NOT FIND INSTALLABLE ISAM

[ibeetb]

When using ADO.NET, here is my code to bring in a table from EXCEL:
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _

& "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _

& "Extended Properties=Excel 11.0;"

When it tries to OPEN my connection, I receive the following error:

COULD NOT FIND INSTALLABLE ISAM!

PLEASE HELP!

 

[Nicole Calinoiu]

This is a well known installation problem for Access 97 and Access 2000.
Please see http://support.microsoft.com/default.aspx?scid=kb;EN-US;209805
for details on how to fix it.

HTH,
Nicole

 

[ibeetb]

I did that...it still didn't work. By the way, I am not using acces. I
created a table in Excel

 

[Nicole Calinoiu]

You are using the Jet database engine to connect to your Excel file. The
Jet engine is the main database engine that runs behind Access, so many
folks just think of it as "Access" rather than Jet. What you've got is a
Jet 4.0 engine that can't find the IISAM for Excel, so it can't load any
Excel file.

When you say "I did that", what exactly do you mean? The KB article to
which I pointed contains multiple possible actions. What did you do?

 

[ibeetb]

My Mistake: I had Extended Proprties=Excel 11.0 (which is the version I am
using). What I realized is that Jet is not supported for anything after 8.0.
Do you have any idea what the alternative is for Extended properties =
annything greater than 8.)???

Even though 8.0 will work with my version of 11.0 (which is Excel 2003)

 

[Nicole Calinoiu]

Use "Extended Properties=Excel 8.0". This refers to the version of the file
you are attempting to open, not the version of Excel you are running. The
Excel workbook file format hasn't changed since Excel 97.

HTH,
Nicole