Could not find installable ISAM

  • Thread starter Thread starter Tommy Malone
  • Start date Start date
T

Tommy Malone

I'm attempting to read from an Excel file with a oledb.oledbconnection and
get an error "Could not find installable ISAM".

How does one fix this problem and does this fix need be done in both design
time and deployment to the client (as with .net framework)?

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

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


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Dim _cn As New OleDb.OleDbConnection

_cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
OpenFileDialog1.FileName & ";Extended Properties=Excel 8.0;HDR=YES;"

I cannot _cn.open. Throws error. "Could not find installable ISAM"

Is there a specific reference which has to be included in the solution?



 
The problem appears to be in the "HDR=YES" portion of the connection string.
When I remove that portion, all works as advertised.

Anyone have any thoughts on this?

Tommy Malone said:
Dim _cn As New OleDb.OleDbConnection

_cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
OpenFileDialog1.FileName & ";Extended Properties=Excel 8.0;HDR=YES;"

I cannot _cn.open. Throws error. "Could not find installable ISAM"

Is there a specific reference which has to be included in the solution?
Click to expand...
 
Also, upon inspection of the dataset that is loaded with a simple fill, the
header row is assumed. I guess the question now is, what if you don't have a
header row?

Tommy Malone said:
The problem appears to be in the "HDR=YES" portion of the connection string.
When I remove that portion, all works as advertised.

Anyone have any thoughts on this?
Click to expand...
 
¤ Also, upon inspection of the dataset that is loaded with a simple fill, the
¤ header row is assumed. I guess the question now is, what if you don't have a
¤ header row?
¤

Then you specify HDR=NO in the connection string. I'm assuming you worked out the syntax problem
(missing sets of double quotes in your example) that was causing the ISAM error?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
I had to remove the HDR=NO from the connection string to overcome the
problem of the installable ISAM. I'm not clear what the double quote issue
is. At this time I am not using any "" in my string.

 
¤ I had to remove the HDR=NO from the connection string to overcome the
¤ problem of the installable ISAM. I'm not clear what the double quote issue
¤ is. At this time I am not using any "" in my string.
¤

Here it is again. Please note the extra sets of double quotes when using additional Extended
Properties arguments:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\INV_xls.xls;" & _
"Extended Properties=""Excel 8.0;HDR=NO;"""

Any deviation from the above syntax will generate the installable ISAM error message.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top