data2access: writing data into MS Access via 32bit R session script

In vh-d/odbc32: 32-bit ODBC drivers for 64-bit R sessions

Description

Procedure for easier exporting of data from an R into MS Access database via separate 32-bit R session script

Usage

data2access(
  data,
  accdb_file,
  overwrite = FALSE,
  fast = TRUE,
  safer = TRUE,
  rownames = FALSE,
  ...
)

Arguments

data	a named list of tables
accdb_file	path to accdb file
overwrite	logical; TRUE for an attempt to drop each table first.
fast	passed to RDOBC::sqlSave
safer	passed to RDOBC::sqlSave
rownames	passed to RDOBC::sqlSave
...	passed to RDOBC::sqlSave

Details

overwrite

logical; Attempt to drop any existing table of the name before writing data?

convert_dates

character; Convert dates as text before writing into database.

vh-d/odbc32 documentation built on Dec. 25, 2019, 8:47 p.m.