Read File

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

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.
 
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.
 
Back
Top