create and edit txt file (1 Viewer)

[Nishikawa]

Hi,

Can anyone teach me how to create and edit a text file usinb vba?
I am unable to be use:
DoCmd.TransferText acImportDelim, , "tableName", "c:\test.txt"
as I am not apeending an entire table.

 

[Galaxiom]

Use a query to extract the data you want and transfer that to the text file.
The same command except "tablename" becomes "queryname".

 

[ajetrumpet]

Can anyone teach me how to create and edit a text file usinb vba?

here is one thing you can do that transfers textbox typings into the text file. you have to open the file for input/output to transfer text in and out of it, just like a stream object is used.

 

[Nishikawa]

thanks so much for your help guys!! It works!