mdb_array: Export Table As List Columns (mdb-array mimic)

In mdbr: Work with Microsoft Access Files

Export Table As List Columns (mdb-array mimic)

Description

mdb-array(1) emits C source; this wrapper returns a named R list of columns while keeping equivalent database/table inputs.

Usage

mdb_array(path, table, columns = NULL, n = -1L)

Arguments

path	Path to .mdb/.accdb file.
table	Table name.
columns	Optional character vector of columns.
n	Optional row limit (⁠LIMIT n⁠).

Value

Named list, one entry per selected column.

Examples

db <- mdbr:::.mdb_example_nwind_path()
if (nzchar(db)) {
  arr <- mdb_array(db, "Products", columns = c("ProductID", "ProductName"), n = 2)
  str(arr)
}

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