Excel

[Skwish]

Hi,

I get the following error

"Could not find installable ISAM"

using the following code in VB.NET 2003 with office 2002 installed

Dim Dataset As New System.Data.DataSet
Dim ExcelCommand As System.Data.OleDb.OleDbDataAdapter
Dim ExcelConnection As System.Data.OleDb.OleDbConnection

ExcelConnection = New System.Data.OleDb.OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=C:\temp.xls; " & _
"Extended Properties=Excel 10.0;")

' Select the data from Sheet1 of the workbook.
ExcelCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [Sheet1$]", ExcelConnection)

ExcelCommand.Fill(Dataset)

ExcelConnection.Close()

Any help would be appreciated to identify what I am missing and how to fix
it.

Thanks,

Stephen

 

[Cindy Meister -WordMVP-]

Hi Skwish,

Yes I have MDAC 2.8 installed, but I still the the ISAM error.

Your connection code is using JET; have you made sure you've
also installed JET? Recently, you've had to download and install
that separately - it hasn't been included as part of the default
MDAC.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.mvps.org/word
http://go.compuserve.com/MSOfficeForum

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail