SQL for "INSERT IGNORE" in MS Access

Returns SQL for inserting all records from table.source that are not yet contained in table.target into table.target

Usage

sqlForInsertIgnoreInMsAccess(db, table.source, table.target, uniqueFields = NA)

Arguments

db

database name or file

table.source

name of source table

table.target

name of target table

uniqueFields

names of unique fields