read_mdb: Read a table as data frame

In mdbr: Work with Microsoft Access Files

Read a table as data frame

Description

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, and character otherwise.

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	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

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

## End(Not run)

mdbr documentation built on May 28, 2026, 5:09 p.m.