sqlForInsertIgnoreInMsAccess: SQL for "INSERT IGNORE" in MS Access

View source: R/sql_top_level.R

sqlForInsertIgnoreInMsAccessR Documentation

SQL for "INSERT IGNORE" in MS Access

Description

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


KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.