Export Query Output to a Table or Flat File

  • Thread starter Thread starter andre
  • Start date Start date
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!
 
-----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
 
Back
Top