export as .csv

M

Michael D. McGill

am creating a macro to export ups tracking number from a query. but the file
has to be .csv format. is there a way to set access to export a file as .csv
in a macro. can't seem to find it.

thanks,
mike
 
V

Van T. Dinh

CSV is actually a Text format so you need to use the TransferText Macro
action.
 

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

Error Message Cannot Update Database is Read Only Error 2950 0
Error When Using TransferText in a Macro 1
Export to CSV no text qualifiers in the header 1
Access Access variable string for export 0
Zip file with Macro 1
Using a Macro to export a query to a .csv file 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Output To text with no headers ? 3

Top