Merging identical tables with different data

  • Thread starter Thread starter Julia
  • Start date Start date
J

Julia

How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables?
 
Julia said:
How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables?
Click to expand...

Use an Update query. The wizard will help you.
 
Julia said:
How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables?
Click to expand...

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.
 
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
 
Back
Top