Need Help Please

[MrRaoof]

My situation is as follows, I have a database containing just over 9,100
records. I am currently trying to update a few fields within these records
from an excel spreadsheet, which was modified from the master DB export.
When I try to import and append a copy, the records do not update because of
the primary key conflict (which is set to a persons SSN). Can someone please
assist me with my issue

 

[Jeff Boyce]

Perhaps some confusion ... do you wish to "update" or "append"?

I can easily see that Access would refuse to "append" records it already
has...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MrRaoof]

I am trying to update.

Perhaps some confusion ... do you wish to "update" or "append"?

I can easily see that Access would refuse to "append" records it already
has...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

What is the SQL statement of your query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MrRaoof]

I have not created a query, i just tried to import the excel file.

 

[John W. Vinson]

I have not created a query, i just tried to import the excel file.

An import will not, and cannot, update existing records. It imports new
records, or causes an error if doing so would create a duplicate.

To update existing records consider using File... Get External Data... Link to
*LINK* to the spreadsheet, and running an Update query joining the linked
table to your local table.