Export the result of a query to a csv file.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,
Is it possible to create a macro (or a vba sub)to export the result of
a query to a csv file.
How should I do it.
I am using Access 97.
Thanks for helping.
Raphael
 
Raphael,

The macro action for this is TransferText.
You will need to run through the process "manually" first, via the
File|SaveAs menu, and when you get to the last screen of the export
wizard, click the Advanced button, and save your setup as a
Specification. Then, when you so your TransferText macro, enter this in
the Specification Name argument of the macro.
 
Back
Top