Export Query As text file

D

Dylan Moran

I would like to export a query as a text file when a user clicks a command
button.
Any help would be appreciated.

Dylan Moran - Melbourne Australia
 
O

Ofer

Use the TransferText command line, check help about the options you can have

docmd.TransferText acExportDelim,,"QueryName","c:\FileName.txt"
 
Top