GIStewart
asked on
Updating a master file in Access
I have a table with a list of employee records, each identified by a unique id, and there are 9 other fields on the table. There are around 25,000 records. I have to maintain this master table as updates to the records are submitted to me. The structure of the update tables is the same as the master table and between 1 and 9 of the non employee id fields may have changed. Is there a query that can be run to elegantly update the master table? Please see attached for a sample of the master table and update table.
EE-update-master-file.mdb
EE-update-master-file.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER