Ms Access Upsert (update/insert) Sql

I know this question must have been asked a million times but I have yet to find a 'NON-VBA' solution to this in MS Access 2007 SQL. I am using 2 Tables TBLDestination and TBLSourc

Solution 1:

Access DOES have the equivalent using an UPDATE with a LEFT JOIN. See here.

Solution 2:

MS Access doesn't have an equivalent to UPSERT where you can do both in a single query.

However, you can get the same effect by doing an UPDATE query where you join to the table you want to update from. Then you do an INSERT query where you OUTER JOIN to the table and return only those where it doesn't exist.