Combining duplicate tables w/ different data

  • Thread starter Thread starter TTVG
  • Start date Start date
T

TTVG

We have a tracking system setup on the network and one of
the users performed a local save to their computer and
have been working off of the same database as the rest of
the staff, therefore I have two copies of the same
database and one of the tables contains different
information than the other. Is there a way to combine
the tables from the two databases, all of the tables
contain the same columns. Any assistance is greatly
appreciated!!!!
 
You might be able to link to the tables from one to the other and perform
append queries. This all depends on your use of autonumber fields, if you
have set integrity between tables, and other factors.
 
Back
Top