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.

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")
#> Warning: database not found: path/to/site.accdb