mdbr (version 0.2.1)

read_mdb: Read a table as data frame

Description

Use export_mdb() to write a table as a temporary CSV file, which is then read as a data frame using readr::read_delim().

Usage

read_mdb(file, table, col_names = TRUE, col_types = NULL, ...)

Value

A data frame.

Arguments

file

Path to the Microsoft Access file.

table

Name of the table, list with mdb_tables().

col_names

Whether or not to suppress column names from the table.

col_types

One of NULL, a readr::cols() specification, or a string. See vignette("readr") for more details. Use TRUE to create a generic readr::cols() specification with mdb_schema().

...

Additional arguments passed to readr::read_delim().

Examples

if (FALSE) {
read_mdb(mdb_example(), "Airlines")
}