Read a table as data frame — read

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

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

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().

A data frame.

if (FALSE) { # \dontrun{
read_mdb(mdb_example(), "Airlines")
} # }