[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.