If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Read File
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. |
#2
|
|||
|
|||
Read File
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. |
Thread Tools | |
Display Modes | |
|
|