Export Query Output to a Table or Flat File

A

andre

Does anyone know how to export the output of an Access
query to a new database table or to a flat text file?

Thanks!
 
S

Steve

-----Original Message-----
Does anyone know how to export the output of an Access
query to a new database table or to a flat text file?

Thanks!
.
Click to expand...
try this


DoCmd.TransferText
acExportDelim, ,"qryInvoicesTXT", "Steve", False


qryInvoicesTXT is my query and Steve is the .txt file I
want to create.

good luck
 
Top