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?????
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?????