Upsert? (1 Viewer)

Nirious

Registered User.
Local time
Today, 16:38
Joined
Jul 31, 2004
Messages
106
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?
 

Banana

split with a cherry atop.
Local time
Today, 07:38
Joined
Sep 1, 2005
Messages
6,318
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.
 

Users who are viewing this thread

Top Bottom