Dim MyConnection As System.Data.OleDb.OleDbConnection
Try
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='" & EditBox1.Text & " '; " & "Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [sheet1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "Attendence")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
Dim i As Integer
For i = 0 To DtSet.Tables(0).Columns.Count - 1
UiComboBox1.Items.Add(DtSet.Tables(0).Columns(i).ToString())
UiComboBox2.Items.Add(DtSet.Tables(0).Columns(i).ToString())
Next
MyConnection.Close()
UiGroupBox2.Enabled = True
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical)
MyConnection.Close()
End Try