sending tables to another database
I am making a series of queries that I will be running for different quarters of information. The queries are making tables that are exported to a different database each quarter. Is there a way by using VBA that I can name these tables and also specify what database I want these tables to go to without having to change the information for each query in the Make table window everytime.
Thank you for your help.