read_mdb {mdbr}

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

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

Value

A data frame.

Examples

## Not run: 
read_mdb(mdb_example(), "Airlines")

## End(Not run)