I am receiving some Excel data that I need to import in to an Access 2013 database on a weekly basis.
The spreadsheet is really simple, just 3 columns
Reference, Total Qty Shipped, Total Value Shipped
If I clear out all the records from the table it imports fine, but if I try the import again it errors with
Now Reference is an indexed field - it's the factory code. I just want this import to refresh the values for the other two columns, overwriting anything there. There are many other fields in the database for each record, so I can't just replace the data.
I'm sure this is a common issue but how do I get around it?
Simon