By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Read File

P: n/a
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.

Mar 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

<co*********@gmail.comwrote in message
news:11**********************@h3g2000cwc.googlegro ups.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.
Mar 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.