importing table data

[CEV]

Somehow we ended up with 2 copies of a database and data was entered into
each of them. Is it possible to import the data from a table in one database
to a table in another database that already has existing records in it? If
so, how can I do this?

Thank You,

CEV

 

[Guest]

You can link all the tables from the second in the first then run append
queries.

BUT the problem is in adding duplicate records or overwriting new data with
old if records have been updated. If all you have been doing is adding
records then there is no overwrite problem.

 

[Guest]

A simple append query will add the data to your master table. But, as
mentioned by another responder, you'll have to deal with duplicate records.

One possible solution to that problem is to decide which table you want to
keep intact, and then set a primary key in it disallowing duplicates. Then
append to that table and any duplicate key values will be blocked.

Alternately you could merge the tables and then run a duplicates query, and
manually decide which to delete ( or depending on what data is in the table
you could come up with a rule to decide which to keep and put that in a
query. ).

 

[CEV]

Thanks for the responses. There should be no duplicates so that will make it
a lot easier.

Thanks,

CEV