How to automate the export of select query

[Guest]

How do I automate the export of a select query?

The macros and VBA favor exporting tables ... but I want to automate the
exporting of the query. I do not want to create a table because it increases
the size of the database. I could create a table, export it, delete it, then
compact the database, but these combined processes take a long time ...
especially if a user want to run several exports.

Any suggestions?

DevDan

 

[Guest]

You can use the name of a select query instead of a table name in the
Transfer... actions.

 

[Guest]

Thanks, Klatuu, your suggestion worked! I love this site!

DevDaniel