|
-
Jul 11th, 2004, 10:50 AM
#1
Thread Starter
Member
Selecting the first sheet in an Excel workbook
When accessing Excel data I use;
MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [Sheet1$]", MyConnection)
All help files etc. I've read till now use this to select all data from the sheet with name "Sheet1", but I do not know the name of the sheet, so is there a way to select the first sheet no matter it's name?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote