getAccessTable: Retrieve an MS Access (R) table from an 'mdb' or 'accdb'...

Description Usage Arguments Value Examples

View source: R/getAccessTable.R

Description

This function is a wrapper around RODBC function to get a table from an mdb or accdb file.

Usage

1
2
getAccessTable(file = NULL, table = NULL, user = "admin", pw = NULL,
  ...)

Arguments

file

path to the mdb or accdb file

table

table name

user

username (login to the file)

pw

password (login to the file)

...

other arguments passed to sqlFetch

Value

The function return a data.frame with data from the specified table.

Examples

1
2
3
4
  ## Not run: 
 getAccessTable(file="C:/prova.accdb", table="Tabella1")

## End(Not run)

lbraglia/yapomif documentation built on May 20, 2019, 11:26 p.m.