I am trying to export the results of queries in one database to another database. I know that I can go into each query from query design and type where I want the tables to go, but what I would like is to be able to export the results of these queries to a new database as named tables. I think I must be missing an obvious way to do this, but thought maybe someone here could help. This is program that will be run quarterly, so I want the output of these queries to be saved as tables in another database for each quarter.

Thanks for your help!

Are you creating a new database each time?

I would suggest using DoCmd.TransferDatabase. Look this up in VBA Help for the syntax.

Do you need more help with this? If so, post some particualrs. It may also be that you will want to append the query results to a table, and then transfer the table.


mmcdonal