troubleshooting Question

Access VBA - Copy tables to another database in same table

Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft AccessVBA
2 Comments1 Solution10 ViewsLast Modified:

I have an Access database called "Source Data.accde" that is on my client's computer. I want to send them a database called "New Tables.accdb" that has a single form with a button that on click calls VBA code that pushes these tables to the "Source Data.accde" database, which is in the same folder.
The reason I am doing this is because the client is confused about how to import tables. How would I do this?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
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 1 Answer and 2 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