Below is an example of how my excel spread sheet is formatted.
I would like to take the contents and save them into a dataset. The first eight columns are associated with each row to the right (if that makes sense).
I am able to query the rows that have data but that's as far as I have gotten.
Any guidance would be appreciated.
Dim str As String = lsbTabs.GetItemText(lsbTab
Dim DtSet As System.Data.DataSet
Dim MyConnection As System.Data.OleDb.OleDbCon
Dim MyCommand As System.Data.OleDb.OleDbDat
Dim connstring As String = "Provider=Microsoft.ACE.OL
& "Data Source=" & someExcelFile & ";Extended Properties=""Excel 12.0;HDR=NO"";"
MyConnection = New System.Data.OleDb.OleDbCon
MyCommand = New System.Data.OleDb.OleDbDat
select * from [" + str + "$] WHERE F1 <> '' AND F2 <> '' AND F3 <> '' AND F4 <> '' AND F5 <> ''", MyConnection)