SQL for "INSERT IGNORE" in MS Access

Source: R/sql_top_level.R

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

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