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

  • Thread starter Thread starter Amazing Butterflies
  • Start date Start date
A

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
 
If the "records" have unique identifiers, you could use an "Update" query
instead of an "Append" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top