Copying data from one table to another

[bash]

Hi,

I have 2 identical databases and I am looking to merge the tables into one
without having to recreate the relationships again.

I've tried the the Import tool, however that just creates another table but
doesn't merge/update the destination table.

Cheers

 

[Olduke]

You will have to create an append query to copy the data from your linked
table to your existing table.

 

[bash]

Thanks, but will this update all the records?

You will have to create an append query to copy the data from your linked
table to your existing table.

 

[gllincoln]

Hi Bash,

Merging can get complicated - if the tables contain some duplicate records
and transaction entries. Then we have to dedupe and make some executive
decisions at times, regarding which table is authoritative for a given item
and why.

If the tables have the same structures but contain only separate and unique
records then it's easy. If you are a VBA programmer, you can connect from
database one to database two via ADO or DAO - and append one recordset to
the other.

Or, from database one you can link the tables you want from database two,
then create an append query like this one.

INSERT INTO [TargetTable]
SELECT [SourceLinkedTable].*
FROM [SoureceLinkedTable];

Gordon