How can I update existing table fields in Access by importing from an Excel spreadsheet?

Question

I have Access 2002 and am running Windows XP. I would like to update certain fields by using data imported from an Excel spreadsheet by specifying the key record number and contents of the target fields.
My spreadsheet has the proper headings corresponding to the table field names.
I can add new records okay and even insert a record to replace a deleted one.
When I try to do an update, I get the message that records were lost due to primary key violations.
I tried deleting the data in the target fields, but that didn’t work. Thanks for any help you can give.

Answer 1

Some of your access tables are indexed so as not to allow duplicates. So when duplicates are encountered while importing from Excel, it is automatically dropped.
Fiddle around a bit more. You should be able to solve it.