Combining MDB files

[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?

 

[Ken Snell [MVP]]

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.