ERROR HELP:COULD NOT FIND INSTALLABLE ISAM

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

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!
 
I did that...it still didn't work. By the way, I am not using acces. I
created a table in Excel
 
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?
 
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)
 
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
 
Back
Top