Combining MDB files

  • Thread starter Thread starter Frank J. Reda
  • Start date Start date
F

Frank J. Reda

I have multiple MDB files with exactly the same structure (but different
data). I would like to combine the multiple MDB files into a single file,
merging the data into single tables rather than multiple instances of the
same tables. Is this possible?
 
Open one of the files, link to the tables in the other files, create a union
query to combine all records from all tables, and then create an append
query that uses that union query as the "source table" to copy the data into
a new table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge multiple mdb files 17
Combine 10 mdb files with different fields but common emp codes 3
searching multiple tables 2
Access 2003 with over 1 million records on a single file 7
Multiple (two) back-end MDB's. 15
Is there any tool that will 'concatenate' say 300 ".mdb" files intoa single .mdb file? 15
Combining databases - Common People table, many other tables. 4
Can Linux extract data from .MDB file, and output to text ? 1

Back
Top