ISAM not found

[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

 

[Cor Ligthert[MVP]]

If you don't find it here, then search the group

Microsoft.public.dotnet.framework.adonet

http://groups.google.com/group/micr...es.vb&q=isam+not+found&qt_g=Search+this+group

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

Cor

 

[Cor Ligthert[MVP]]

If you don't find it here, then search the group

Microsoft.public.dotnet.framework.adonet

http://groups.google.com/group/micr...es.vb&q=isam+not+found&qt_g=Search+this+group

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

Cor

 

[friend]

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

 

[friend]

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