List tables in a Microsoft Access database

mdb-tables is a utility program distributed with MDB Tools. It outputs the names of all user tables (or other object types) in an MDB database file.

mdb_tables(
  file,
  system = FALSE,
  type = c("table", "query", "systable", "any", "all", "form", "macro", "report",
    "linkedtable", "module", "relationship", "dbprop"),
  show_type = FALSE
)

Arguments

file: Path to the Microsoft Access file.
system: Logical; include system (MSys*) tables. Equivalent to -S.
type: Object type to list: "table" (default), "query", "systable", "any", "all", "form", "macro", "report", "linkedtable", "module", "relationship", or "dbprop". Equivalent to -t.
show_type: Logical; prefix each entry with its type. Equivalent to -T.

Value

A character vector of object names.

Examples

db <- mdb_example()
mdb_tables(db)
#> [1] "Order Details" "Orders"        "Products"      "Shippers"     
#> [5] "Categories"    "Customers"     "Employees"     "Suppliers"    
#> [9] "Umsätze"      
mdb_tables(db, type = "query")
#>  [1] "Alphabetical List of Products"   "Catalog"                        
#>  [3] "Category Sales for 1995"         "Current Product List"           
#>  [5] "Customers and Suppliers by City" "Employee Sales by Country"      
#>  [7] "Invoices"                        "Invoices Filter"                
#>  [9] "Order Details Extended"          "Order Subtotals"                
#> [11] "Product Sales for 1995"          "Products by Category"           
#> [13] "Quarterly Orders"                "Quarterly Orders by Product"    
#> [15] "Sales by Year"                   "Sales Totals by Amount"         
#> [17] "Summary of Sales by Year"        "Ten Most Expensive Products"    
#> [19] "Orders Qry"                      "Products Above Average Price"   
#> [21] "Sales by Category"               "Summary of Sales by Quarter"