Export query to a csv file.

**swedni** · 01-13-2015, 06:43 AM

Is it possible to export a query to a CSV file whit macro?

**JoeM** · 01-13-2015, 07:08 AM

Yes. Use the TransferText Macro Action.
What you usually want to do is go through the process once manually, and just before you export the file, click on the Advanced Tab and save the Export Specification. Then use that Export Specification in the TransferText Action.

**swedni** · 01-13-2015, 07:48 AM

Many thanks. You solved the problem for me.

**JoeM** · 01-13-2015, 08:01 AM

You are most welcome.
Glad to help!

Export query to a csv file.

Thread Tools

Export query to a csv file.

Similar Threads

VBA Code to run a query and then export the query as a fixed width .txt file

I want to export multiple queries into an excel file, each query on a different sheet

Export Query to .ODS file starting at a specific cell

How to export/save a Query or Report as Text File?

Export a simple query result to an excel file

Posting Permissions