Using a Macro to export a query to a .csv file

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a macro that I am using to export a query to an
excel file. I was wanting to know if I could export this
to a .csv file, without exporting the field names, and
with no text qualifier. If I open the query directly, and
choose Export, and then select (.txt, .csv....) I get the
option to do these things. Is there a way to do this from
within the macro?

Thanks for your help.
 
David,

Sorry, but I know about this stuff... TransferText is the correct way
to export to csv.

A csv file is nothing but a comma-delimited text file with a .csv
filename extension. You will need to use an Export Specification. If
you need more help with this, I am happy to oblige.
[/QUOTE]
 
Back
Top