read text file into dataset

[nswan]

Hi,

i'm reading a text file into a data set with the code below

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

[Hole-In-One]

How are you writing the text file (streamwriter)?

If you are writing the text file just write some Bulls**t on the first line!