read text file into dataset
Hi,
i'm reading a text file into a data set with the code below
Code:
strConnection = "Provider=Microsoft.jet.oledb.4.0; data source=c:\; Extended Properties=Text;")
Dim myConnection as new oledbdConnection(strConnection)
Dim daInput as new oledbDataAdaapter("select * from textfile.txt", myconnection)
dim dsInput as new dataset
daInput.Fill(dsInput)
It works ok, but it doesn't read the first line of the text file. I pressume it's coz it thinks it's a header, although the file doesn't have one. How do I get it to read the first line in?
many thanks
Nick