N
NewtoComputing
I apologise in advance if this is an aggravating question.
I want to have 2 tables. Both have exactly the same fields/column
definitions. One is a "master" table containing existing data. The "other"
table is empty except for a few cells of updated data and the Primary Key
field (ID).
Can I merge or append the two so that the few cells of updated data in the
"other" table replace their matching cells in the "master" table without
changing any other cells in the "master" table?
I want to have 2 tables. Both have exactly the same fields/column
definitions. One is a "master" table containing existing data. The "other"
table is empty except for a few cells of updated data and the Primary Key
field (ID).
Can I merge or append the two so that the few cells of updated data in the
"other" table replace their matching cells in the "master" table without
changing any other cells in the "master" table?