ADO connection to a tab delimited file

I have created an ADO connection to a tab delimited file. This connection
is used with a ADODB recordset.

Similar to normal SQL, I wish to say something like:

SELECT fName, sName WHERE left(sName,1) = 's'

However.....the columns in the ASCII text file do not have column headings.

So....how in my SELECT statement would I refer to the 8th column?

Thanks in advance

Griff


.