Scroll to navigation

mdb-json(1) Executable programs or shell commands mdb-json(1)

NAME

mdb-json - Export data in an MDB database table to JSON.

SYNOPSIS

mdb-json [-D fmt] [-T fmt] [-U] database table
mdb-json -h|--help

DESCRIPTION

mdb-json is a utility program distributed with MDB Tools.

It produces a CSV (comma separated value) output for the given table. Such output is suitable for importation into databases or spreadsheets.

OPTIONS

Set the date format (see strftime(3) for details).
Set the date/time format (see strftime(3) for details).
Change unprintable characters to spaces (otherwise escaped as \u00XX)

NOTES

ENVIRONMENT

Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
semi-column separated list of options:
  • use_index
  • no_memo
  • debug_like
  • debug_write
  • debug_usage
  • debug_ole
  • debug_row
  • debug_props
  • debug_all is a shortcut for all debug_* options

SEE ALSO

mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1) mdb-import(1) mdb-parsecsv(1) mdb-prop(1) mdb-queries(1) mdb-schema(1) mdb-sql(1) mdb-tables(1) mdb-ver(1)

HISTORY

mdb-json first appeared in MDB Tools 0.9.

AUTHORS

The mdb-json utility was written by Ugo Di Girolamo. It is based on mdb-export(1).

04 January 2021 MDBTools 0.9.1