If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging identical tables with different data
How can I merge two databases in to one with identical structures and
identical table structures, but with different data in the tables? |
#2
|
|||
|
|||
Merging identical tables with different data
Julia wrote:
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 E. Meehan 26 + 6 = 1 It's Irish Math |
#3
|
|||
|
|||
Merging identical tables with different data
Julia wrote:
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. -- Joseph E. Meehan 26 + 6 = 1 It's Irish Math |
#4
|
|||
|
|||
Merging identical tables with different data
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. Rosco ----- Julia wrote: ----- How can I merge two databases in to one with identical structures and identical table structures, but with different data in the tables? |
Thread Tools | |
Display Modes | |
|
|