Importing data from Excel sheet and replacing exisiting data

[Gangrel]

I have spreadsheets that I need to regularly import into an Access database. However, most times the spreadsheets contain updates to exisiting rows, and not brand new data.

So, when I try to use the simple import command, it complains about the key violations.

is there a way to do an import/replace? I can't find it, though that may be to my lack of sleep!

 

[lupins46]

No there isn't.

You would have to import or link to the source and then create separate queries in Access 1)to Update existing records and 2) to Add new ones.