Well I am not sure were could be the error.I used excel and this is
what I wrote to perform the action to pop data into grid.

Sub popgrid()
Dim con as new oledb.oledbConnection("Provider...)
con.open()
dim cmd as new oledb.oledbcommand(select * from table",con)
dim da as new oledb.oledbDataadapter(cmd)
dim ds as new dataset()
da.fill(ds)
datagrid.datasource = ds
con.close

for me this worked out.Hope this is helpful.

Pavi