Read a table as data frame — read

Reads a table directly from a Microsoft Access database using the bundled mdbtools C library. Column types are inferred from the MDB schema: integer, double, logical, POSIXct for DateTime columns, character text, and raw-vector list columns for binary and OLE fields. This eager convenience function reads the entire table into memory; use mdb_stream_table() for bounded batch reads.

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: Logical; when FALSE columns are named V1, V2, etc.
col_types: Ignored. Type coercion is now handled automatically by the native reader.
...: Ignored. Extra arguments were previously forwarded to readr::read_delim(), which is no longer used.

Value

A tibble.

Examples

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