You can attach the Excel file. Choose Get External on the File menu.

Once attached, you can create a query to find the record you want, and read
the value from the field.

If you want to export it to a text file, use TransferText in a macro to
export the attached Excel "table."

If you really want to read a text file line by line, see help in the VBA
window on Open.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Anna" wrote in message
oups.com...
Hi:Can any one please tell me how to convert excel file into a text
file thru VB6 Program? Also is it possible that i read the values from
the converted text file of any column one by one thru do while loop?
Or can i read the values of any column directly from excel file
without converting into a textfile thru do while loop?

Thanks,
Anna.