Hi all,
I'm sure this is a newbie question - my apologies in advance. I've searched around, but don't understand how to get this to work.
I can follow SQL and VBA, and am a rank beginner at Access
I wish to create a system for importing a table from excel and updating a master database with new/modified records from the imported table.
the records in each table can be matched using [Name] and [dDate] fields (this combo is unique)
I have a table (tbl_FromExcel) with my imported data. I wish to overwrite/update all data fields (assume fF1, fF2, fF3, and fF4 for this example) where records in the master database (WeeklyKPIs) differ and to create those that don't exist.
Is there a simple SQL based query command to do this?
Thanks
Werafa