access_query_32: Get data from MS Access

In Acanthiza/envImport: Combine Disparate Data Sources

Get data from MS Access

Description

Generates an instance of 32-bit R, queries the database 'db_path' to retrieve the table 'db_table' and makes the table available as the object 'table_out'. Modified from the Stack Exchange Network post by manotheshark.

Usage

access_query_32(db_path, db_table = "qryData_RM", table_out = "data_access")

Arguments

db_path	Character. Path to MS Access database.
db_table	Character. Name of table within database.
table_out	Character. Name of object to which the table is assigned.

Value

Makes the table available as the object 'table_out'.

Examples

 access_query_32(db_path = "path/to/site.accdb", db_table = "sites", table_out = "sites")

Acanthiza/envImport documentation built on Sept. 6, 2024, 12:44 a.m.