I have a situation where I've contructed a query in Database 1, and I would like to export this query (using VBA) to another database (Database 2), but when I export the query, I would like it to be saved as a TABLE in Database 2. Basically, I want to copy/export the information contained in the query located in Database 1, and save it as a table in Database 2.
1. Database 1 is an open database, and contains the query to be exported.
2. Database 2 is an existing database, is not open, and we'll say is located at:
C:\Documents and Settings\GIS Admin\Desktop\Delete\Database 2.accdb
I don't know if this is possible, so I thought that I would see if anyone in the EE community has any suggestions.
Any help is appreciated.