EXCEL SHEET TO DATAGRIDVIEW

See more:

VB

Hi,
I have an excel sheet named"Ispis" with 2 tables each having 6 columns
Before Table1 are some data and also there are some data between Table1 and Table2
Table1 with headers starts at B16:G16 and ends at B62:G62
Table2 with headers starts at B91:G16 and ends at B118:G118
I want to load Table1 to DataGridview1 and Table2 to Datagridview2
My code does not work because there are some data before table1
My Code

Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\Users\korisnik\Desktop\" & File.Text & "';Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select Sifra, Amount from [Ispis$];", MyConnection)
MyCommand.TableMappings.Add("Table", "Net-informations.com")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)

Please help