Jedidia
asked on
Select specific rows within Excel
I have the following select
MyCommand = New System.Data.OleDb.OleDbDat aAdapter(" select * from [Sheet1$]", MyConnection)
How would I configure the select statement to start on a specific row (say row 14) and go until the there were no more rows with data?
MyCommand = New System.Data.OleDb.OleDbDat
How would I configure the select statement to start on a specific row (say row 14) and go until the there were no more rows with data?
ASKER
Hi Webtubbs - This works great for starting at row 14, but is there also a way to identify the last row with data and the select stops at that row?
I am passing this to a datatable and it adds ALOT of empty rows in my datatable..:)
I am passing this to a datatable and it adds ALOT of empty rows in my datatable..:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MyCommand = New System.Data.OleDb.OleDbDat
Wayne