Help with updating a table and adding records

[NHelaMS]

I am trying to set up a database that has Job ID, Description, Start Date and End Date as fields. Each week I will receive a .dbf file that is a table with the same fields but different headers. What I want to do is run something and update my original table (keying off of the Job ID code), change any inforamtion that is old in the original table and add new records for lines in the "updates" table that dont exist in my original table. Any help would be greatly appreciated.

Thanks.

 

[GoDawgs]

You'll just need an Append and Update query if the incoming table is the same every week. Hope that helps.

Kevin