Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to create txt file?

Status
Not open for further replies.

aqm

Programmer
Aug 26, 2002
65
0
0
AO
hi,
how can i create a .txt file through vb code?
help.
aqm
 
It all depends on what format you want the text to be in. If you just want to be able to enter text into a field, and then output that text to a file, then use VBA's Open command. What are you trying to do?
 
I think aqm just wants regular text saved to a binary file (.txt.).
 
If you want to export Table Data to a txt file try this

DoCmd.TransferText acExportDelim, , "MyTableName", MyPathName & MyFileName & ".txt", -1

See also Help for TransferText.

bye
Fabio
 
hi
sorry, i was on lunch.

I wants regular text saved to a binary file (.txt.).
aqm
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top