Can you update - not append- records in access with excel upload?

[Amazing Butterflies]

I have created a query with a list of clients to call today, then exported to
excel.
This list contains fields that need to be updated in acess after the calls
have been made. Instead of updating each record manually, I would like to
upload the spreadsheet with the updated data back into access.
I can't see how to update the records instead of appending new records.

Thanks in advance

JMuniz

 

[Jeff Boyce]

If the "records" have unique identifiers, you could use an "Update" query
instead of an "Append" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP