F
friend
Hello all,
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0;data source='C:\test.xls';Extended
Properties=Excel 8.0;HDR=YES;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * From
[Tabelle1$]", MyConnection)
1. When I use HDR option either Yes or no...I am getting an error
"ISAM not found"
2. Here I am hardcoding the sheet name i.e., Tabelle1...how to make it
in general ie., getting the sheet names
How to resolve these issues ??
thanks for any help
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0;data source='C:\test.xls';Extended
Properties=Excel 8.0;HDR=YES;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * From
[Tabelle1$]", MyConnection)
1. When I use HDR option either Yes or no...I am getting an error
"ISAM not found"
2. Here I am hardcoding the sheet name i.e., Tabelle1...how to make it
in general ie., getting the sheet names
How to resolve these issues ??
thanks for any help