Combining Like Tables in different Access Databases

I would like to combine multiple tables that have identical structure but reside in different databases.  I can select each record and insert it into a master but I am looking for something better and faster.  Any ideas?
pat_cunninghamAsked:
Who is Participating?
 
cquinnConnect With a Mentor Commented:
You can run an append query in Access which selects data from an external database and combines it with a table in the current database.

For example, if the tables you are wishing to combine are both called tblClient, open up one database and run a query with syntax like this:

INSERT INTO tblClient
SELECT tblClient.*
FROM tblClient IN "C:\test\Otherfile.mdb";


This will take data from a table called tblClient in a database called Otherfile.mdb located in the C:\test\ directory and add it to the tblClient table in the currently open database

You will have problems if you have duplicated data
0
 
pradapkumarCommented:
what's your Database?
Oracle/MySQL?
0
 
pat_cunninghamAuthor Commented:
Access
0
 
pradapkumarCommented:
you need to made all the tables available with some reasonable unique name at a single database. Then only your aim will be served easily.
0
 
pat_cunninghamAuthor Commented:
I dont understand.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.