ISAM not found

  • Thread starter Thread starter friend
  • Start date Start date
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
 
If you don't find it here, then search the group

Microsoft.public.dotnet.framework.adonet

http://groups.google.com/group/microsoft.public.dotnet.languages.vb/s...

Most of us have seen this question so often, that I do it this way

Cor




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- Hide quoted text -

- Show quoted text -

Thank u...I solved the problem
 
If you don't find it here, then search the group

Microsoft.public.dotnet.framework.adonet

http://groups.google.com/group/microsoft.public.dotnet.languages.vb/s...

Most of us have seen this question so often, that I do it this way

Cor




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- Hide quoted text -

- Show quoted text -

Thank u...I solved the problem
 
Back
Top