Advice on doing table data comparison

  • Thread starter Thread starter Larry Gravior
  • Start date Start date
L

Larry Gravior

I need some advice on how perform a task in access. I have two tables one
called EmpTmp and another called Emp. The two tables schemas are identical.
Here is my scenario, I'll be importing a text file into EmpTmp, and I must
do a comparison between EmpTmp and Emp for any changed values or new
records. The new records need to be added to Emp of course and changed
fields have to be updated in Emp for each matching record. My PK on both
tables is EmpID. What sort of process would be the best to do a field by
field, row by row comparison to check for any differences and then either
add or update fields accordingly? Your advice is greatly appreciated.


Larry.
 
Larry,

I would do a find unmatched query to identify the records
to be added. Then I would use a query the combines the
tables and finds the values that are not the same and
update to the new values.
 
Back
Top