merging two access databases

A

al

i have two identical databases...i need to make them
one...one has 50000 records and the other 25000...the
column headings are the same...how do i do so


thanks al
 
J

John Vinson

i have two identical databases...i need to make them
one...one has 50000 records and the other 25000...the
column headings are the same...how do i do so


thanks al
Click to expand...

Are these two *DATABASES* - mdb files with potentially many tables,
forms, queries, reports, and other objects? Or two *TABLES*?

If you're talking about tables, you may be able to simply create an
Append query based on one of them, and append the data to the other.
If there are Autonumbers in the tables, or if there may be records in
one table which should not be added because they'd duplicate data that
exists in the other, more effort may be needed. Care to describe in
some more detail?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top