Updating Existing Records from Excel Import

[veraloopy]

Hi everyone

I'm struggling with updating records in my table by importing from an excel spreadsheet.

I have tblContacts with the primary key being [CustRef] and a field called [OtherEnqSource] amongst other fields.

I have 359 records where I want to change the value in [OtherEnqSource] but when I try and import from excel, I keep getting errors around key voilations as the [CustRef] already exists.

I've tried an Update query but do I need to first import the changes into a new temporary table and then update the existing table from there?

any help is greatly appreciated

 

[namliam]

I've tried an Update query but do I need to first import the changes into a new temporary table and then update the existing table from there?

any help is greatly appreciated

Yes that is what you have to do, an alternative could be ... you could link the excel sheet using a linked table.
But either way you need to have it as a table inside the database, then run an update query.

Good luck !