Export Data In An MDB Table To CSV Or INSERT SQL

mdb-export is a utility program distributed with MDB Tools. It produces CSV output for the given table. Such output is suitable for importation into databases or spreadsheets.

mdb_export(
  path,
  table,
  no_header = FALSE,
  delimiter = ",",
  row_delimiter = "\n",
  no_quote = FALSE,
  quote = "\"",
  escape = NULL,
  escape_invisible = FALSE,
  date_format = "%Y-%m-%d",
  datetime_format = "%Y-%m-%d %H:%M:%S",
  null = "",
  bin = c("strip", "raw", "octal", "hex"),
  boolean_words = FALSE,
  insert = NULL,
  namespace = NULL,
  batch_size = 1L,
  n = -1L
)

Arguments

path: Path to .mdb/.accdb file.
table: Table name.
no_header: Logical, equivalent to -H/--no-header.
delimiter: Equivalent to -d/--delimiter.
row_delimiter: Equivalent to -R/--row-delimiter.
no_quote: Equivalent to -Q/--no-quote.
quote: Equivalent to -q/--quote.
escape: Equivalent to -X/--escape.
escape_invisible: Equivalent to -e/--escape-invisible.
date_format: Equivalent to -D/--date-format.
datetime_format: Equivalent to -T/--datetime-format.
null: Equivalent to -0/--null.
bin: Binary mode (strip, raw, octal, hex) for parity.
boolean_words: Equivalent to -B/--boolean-words.
insert: Backend for -I/--insert mode.
namespace: Equivalent to -N/--namespace.
batch_size: Equivalent to -S/--batch-size.
n: Optional row limit (LIMIT n).

Value

Character scalar containing CSV or SQL INSERT text.

Details

Used with insert, it outputs backend-specific SQL INSERT statements. Most formatting options also apply in insert mode.

Examples

db <- mdbr:::.mdb_example_nwind_path()
if (nzchar(db)) {
  cat(mdb_export(db, "Products", n = 2))
}
#> ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued
#> "1","Chai","1","1","10 boxes x 20 bags","18","39"," 0","10","0"
#> "2","Chang","1","1","24 - 12 oz bottles","19","17","40","25","0"