queryAccess32: Get Data from 32-bit Access with 64-bit R

In madlogos/aseshms: Toolkit for ASES HMS Team

Description

When x64 Access driver is missing, you cannot directly fetch data from MS Access using RODBC right now. This is a work-around function to initiate an independent x86 R session to fetch the data, and save the data.frames as an acc32.Rdata file in your work directory.

Usage

queryAccess32(db.path, pwd = NULL, qry.tbl = NULL, out.names = NULL,
  silent = FALSE)

Arguments

db.path	charcter, MS Access db full path
pwd	character, the password to the Access db if applicable. If there is no password, set it NULL (default).
qry.tbl	character vector, SQL queries or tables name.
out.names	character vector, names of the output objects. Must be of the same length as qry.tbl.
silent	logical, if avoid any message. Deafult FALSE.

Value

An Rdata file (acc32.Rdata) in your work directory.

Examples

## Not run: 
queryAccess32("~/test.accdb", qry.tbl=c("User", "select * from Deal;"))

## End(Not run)

madlogos/aseshms documentation built on May 21, 2019, 11:03 a.m.