Import excel dat to update and add new records

[Guest]

How does one import records from an excel spreadsheet and overwrite existing
field data for records with updated information and also add totally new
records at the same time?

One table has Policy Number as a primary key with no duplicates and the
other table has Location ID as primary key with no duplicates.

The importing new records is the easy part and is what I am doing now. I
now need the ability to update existing fields for records in the database.

 

[David Seeto via AccessMonster.com]

I don't think you can do this with the normal Import function in MS Access - you could, however, write a function to do this by (a) importing the spreadsheet into copy of the table, (b) deleting any records in your original table that exist in your import copy, and (c) appending all of the records from your import table into your original table.