Read Excel file into Datagrid using VB.net

[Hitman47]

I want data from an excel file(g:\recordsheet.xls) to be imported into a Datagrid using VB.nwt windows application. I use the following code got from net, but after running the program the datagrid remains blank . What to do??

--------------------------

Imports System.Data.OleDb

Private Sub form1_load()

Dim con As OleDbConnection

Dim da As OleDbDataAdapter

Dim ds As DataSet

Try

con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=g:\recordsheet.xls;Extended Properties=Excel 8.0")

con.Open()

da = New OleDbDataAdapter("select * from [sheet1$]", con)

da.TableMappings.Add("Table", "Details")

da.Fill(ds)

DataGrid1.DataSource = ds.Tables(0).DefaultView

DataGrid1.AlternatingBackColor = Color.Yellow

Catch ex As Exception

MsgBox(ex.Message)

Finally

con.Close()

End Try

End Sub

End Class

[eyeball]

i can see what this code is attempting to do although im more familiar with interacting with access not excel, however i would suggest stepping through the program line by line and finding out for example if the the dataset has been filled with the values from the xls document

let us know how it goes and il help more if i can.