Import a delimited flat file into a new or existing MS Access Database table

Import a delimited flat file into a new or existing MS Access Database table

Usage

importFile(
  dsn,
  db,
  name,
  delim = ",",
  quote = "\"",
  filter = SimpleImportFilter()$INSTANCE,
  useExistingTable = FALSE,
  header = TRUE
)

Arguments

dsn

Input file path

db

a Database object

name

Table name

delim

Delimiter (default (,))

quote

Quote character (default ")

filter

Optional custom ImportFilter object

useExistingTable

logical. Use existing tables? Default: FALSE

header

logical. Input file contains headers? Default: TRUE