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

Transfer Text - Decimal Places 0
Setting a default zoom in Infopath 0
Need Help with Macro Security 1
Converting isse with Export in Outlook 0
Removing double quotes from field names 0
Error When Using TransferText in a Macro 1
How to Write EXCEL files from a FORTRAN Program ? 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0

Top