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

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.
 
G

Guest

-----Original Message-----
David,

The applicable macro action for this is TransferText.

--
Steve Schapel, Microsoft Access MVP


.
thanks anyway i do'nt want text
Click to expand...
 
S

Steve Schapel

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export table to txt file with a variable filename 0
Error When Using TransferText in a Macro 1
export as .csv 2
TransferText export is truncating field 2
Error Message Cannot Update Database is Read Only Error 2950 0
Reposting: How to avoid macro cancelling an export? 2
Export to CSV no text qualifiers in the header 1
Zip file with Macro 1

Top