troubleshooting Question

Export MS Access query to another database as a table (using VBA)

Avatar of giswest
giswest asked on
Microsoft Access
9 Comments2 Solutions811 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros