EXCEL Error -- something about ISAM

Eng

Active member
Joined
Jan 2, 2004
Messages
32
I am trying to run a sample example that reads the EXCEL File into the dataset. I typed the following code as given(except for my file location):

Dim DS As System.Data.Dataset
Dim MyCommand As System.Data.OleDB.OleDbDataAdapter
Dim MyConnection As System.Data.OleDb.OleDbConnection

My Connection = New System.Data.OleDB.OleDbConnection(_
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=C:\myFile.XLS; " & _
"Extended Properties=Excel 9.0;")

MyCommand = New System.Data.Dataset()
MyCommand.Fill(DS) <<== [getting Could not find installed ISAM Error]
MyConnection.CLose()

What am I doing wrong?????
 
Back
Top