Connect to Pipe delimited text file database using ADO

[mark]

I am connecting to a Pipe delimited text file using the Microsoft Text Driver. However when I query this text file it doesnt seem to recognise the columns in my text file. There are no column headers in the text file so I am referring to ech field as F1...to....F8

Any ideas how I can get this to identify which fields I am referring to when running a query?

[tev]

can't you put it into an array ?