exporting results of query

  • Thread starter Thread starter Fred Jacobowitz
  • Start date Start date
F

Fred Jacobowitz

I am trying to write a macro or module that will run a query and then export
the records in the "Microsoft word merge" (.txt) format.

Currently, i do this by keystrokes.

If, I am not mistaking, in earlier version of Access in would start a Record
a Macro and copy the results. This facility seems to be removed.

Thank you,
Fred Jacobowitz
 
Word has the "record a macro", but Access never has.

Create a macro, and use the TransferText action.
In the lower pane of the macro, fill in the details.
Typically you want to Export Delimited Text, and use a file name ending in
".csv" (comma-separated values).
 
Back
Top