Hi people.
I'm having a trouble with this source.
Dim strConn As String = "Provider=Microsoft.Jet.OleDb.4.0;" _
& "data source=c:\teste\teste.xls;" _
& "Extended Properties=Excel 8.0;"
Dim ds As New DataSet
Dim objConn As New OleDbConnection(strConn)
Dim strSql As String = "Select * From [Plan1$] "
objConn.Open()
Dim da As New OleDbDataAdapter(strSql,objConn)
da.Fill(ds , "teste")
Well
the trouble is. when i fill my dataset it gets the first line in my excel sheet and put it like a colum title and make it an invalid line that i can't use any more.
some one knows how can i fix it ?
...
Go to the complete details ...