R
Russ
Hi All,
This is all in Version 2003....
I have an orginal, 2 primary key table with various other fields for each
record (those fields are all subject to change, like emails, names,
addresses, etc). Periodically, I am emailed an Excel sheet with the latest
version from our datawarehouse (same fields as orginal). I would like to
build a query/queries that would:
(1) Keep all unchanged records from the orginal table
(2) Add any new records from the excel sheet
(3) Change any original records where the non-primary key has changed.
The original table would continue to grow, as old data is always kept for
records not in the latest version, etc.
Any thoughts? Thanks so much!
This is all in Version 2003....
I have an orginal, 2 primary key table with various other fields for each
record (those fields are all subject to change, like emails, names,
addresses, etc). Periodically, I am emailed an Excel sheet with the latest
version from our datawarehouse (same fields as orginal). I would like to
build a query/queries that would:
(1) Keep all unchanged records from the orginal table
(2) Add any new records from the excel sheet
(3) Change any original records where the non-primary key has changed.
The original table would continue to grow, as old data is always kept for
records not in the latest version, etc.
Any thoughts? Thanks so much!