MDB Header Summary (mdb-header mimic)

mdb-header(1) writes C files; this wrapper returns a structured summary.

mdb_header(path)

Arguments

path

Path to .mdb/.accdb file.

Value

Named list with version, table names and query names.

Examples

db <- mdbr:::.mdb_example_nwind_path()
if (nzchar(db)) {
  mdb_header(db)
}
#> $version
#> [1] "mdbtools v1.0.1"
#> 
#> $tables
#>  [1] "Order Details"     "Orders"            "Products"         
#>  [4] "Shippers"          "Categories"        "Customers"        
#>  [7] "Employees"         "Suppliers"         "Umsätze"          
#> [10] "MSysObjects"       "MSysACEs"          "MSysQueries"      
#> [13] "MSysRelationships" "MSysIMEXColumns"   "MSysIMEXSpecs"    
#> [16] "MSysModules"       "MSysCmdbars"       "MSysModules2"     
#> [19] "MSysAccessObjects"
#> 
#> $queries
#>  [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"    
#>