Update and add new records

[crug]

Hi all I have a table "tblEmployee" which has "name, employee_no, manager, etc" I recieve from HR a updated spreadsheet which can have new employees or just updates. ie new manager name. I can run an update query to update changes based on the employee_no which is constant. How can i add new starters from this list ?

 

[Pat Hartman]

Create an update query that joins the existing table with the updates table using a right join. This will update all matching records and add any new ones in a single step.

 

[crug]

Thanks i'll give that ta try