How to automate the export of select query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You can use the name of a select query instead of a table name in the
Transfer... actions.
 
Back
Top