Posted by andrew on 11/22/05 12:54

I have two databases with multiple tables. Same tables same fileds.

Both databases contain records, but they should not match each other.

(I will run a report for matches before this and delete any data that
is not current to ensure this is the case)

How do I go about moving data from one of the databases to the other in
order to create a single database with all the data? Unfortunately my
SQL is limited and I cannot image how I would work around the unique
ids. Append or update maybe?

Thanks in advance

Andrew

• Next in forum: Combining INTO with UNION
• Prev in forum: 100 % CPU Usage
• Thread view: How to move two separate databases into one?

[Reply to this message]