possible to combine databases?

  • Thread starter Thread starter Kasey
  • Start date Start date
K

Kasey

Is there a way to combine two separate databases into
one? They share information and a primary key, but one
is older. It would be great to consolidate all data into
one database system.

Thanks!
 
Is there a way to combine two separate databases into
one? They share information and a primary key, but one
is older. It would be great to consolidate all data into
one database system.

Thanks!
Click to expand...

Two *databases* - different .mdb files? or two *tables*?

The answer is YES, BUT. Depending on the overlap between the tables,
how the primary key was assigned (are there duplicate primary key
values in the two tables? are there related tables?) this can be as
simple as an Append query or it can be very tedious, requiring a lot
of manual processing.
 
-----Original Message-----


Two *databases* - different .mdb files? or two *tables*?

The answer is YES, BUT. Depending on the overlap between the tables,
how the primary key was assigned (are there duplicate primary key
values in the two tables? are there related tables?) this can be as
simple as an Append query or it can be very tedious, requiring a lot
of manual processing.


.
Click to expand...
Hi, John.

They are two databases or .mdb files with the same
primary key value-- client ID-- in each table. This ID
is the only thing that ALL the tables share in common. I
imported the tables into the new/updated database,
thinking that that would suffice. Is that ok, or should
I run an Append query? Let me know what you think.

Thanks!
 
They are two databases or .mdb files with the same
primary key value-- client ID-- in each table. This ID
is the only thing that ALL the tables share in common. I
imported the tables into the new/updated database,
thinking that that would suffice. Is that ok, or should
I run an Append query? Let me know what you think.
Click to expand...

Without a lot more information I would not even hazard a guess!

Is ClientID 88 in the table from database 1 the same person as
ClientID 88 in database 2? Or are they different people? Or are there
no duplicates between the tables?

Do you have multiple tables all with ClientID as the Primary Key (VERY
unlikely to be correct design if so)?

Are there clients in common between the two Clients tables? If so,
might they have different ClientIDs?

If there are clients in common, do they have identical information in
all the related tables? or different information? If it's different
information, do you need to override one database's values with those
from the other, or to add new records, or to update existing records?
 
Back
Top