Merge 2 dbs

J

jime

Can I merge 2 dbs in Access 2003? Say one had June data and the other had
exact same data for July.
How would I mere them into one db?
 
J

John Vinson

Can I merge 2 dbs in Access 2003? Say one had June data and the other had
exact same data for July.
How would I mere them into one db?
Click to expand...

Are these two *databases* - .mdb files, with multiple tables, forms,
and reports? Or two *tables*? (Either can be handled but the methods
are different). A UNION query or an APPEND query can be used to
combine the data in two tables.
 
Top