N Nirious Registered User. Local time Today, 21:54 Joined Jul 31, 2004 Messages 106 Oct 21, 2011 #1 Hi, Does access have a syntax for an upsert query. I mean insert record, if key already exists than do an update of the fields for that record?
Hi, Does access have a syntax for an upsert query. I mean insert record, if key already exists than do an update of the fields for that record?
B Banana split with a cherry atop. Local time Today, 11:54 Joined Sep 1, 2005 Messages 6,318 Oct 21, 2011 #2 Unfortunately, there isn't any special upsert syntaxes for Jet SQL. You'd have to do it the ANSI way - update with an inner join then insert using a frustrated join in two separate queries.
Unfortunately, there isn't any special upsert syntaxes for Jet SQL. You'd have to do it the ANSI way - update with an inner join then insert using a frustrated join in two separate queries.
