Merging identical tables with different data

[Julia]

How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables?

 

[Joseph Meehan]

How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables?

Use an Update query. The wizard will help you.

 

[Joseph Meehan]

How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables?

Let me get back to that.

You can use an update query or an append query. An update will not add
a new record where it sees a match of the selected field(s) but will change
data to match the "new" data. An Append query will just add records.

You start by making a standard query and then change the query type to
append or update.

Sorry about the first post.

 

[Guest]

Julia
Write an append query. This will copy the data from one table to the end of the other table, without overwriting the data already there

Rosc

----- Julia wrote: ----

How can I merge two databases in to one with identical structures an
identical table structures, but with different data in the tables