logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

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

Authors

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

MDBTools 1.0.1                                   05 January 2025                                     mdb-json(1)

Description

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

       It  produces  JSON  output  for  the  given  table.  Such  output is suitable for parsing in a variety of
       languages.

Environment

MDB_JET3_CHARSET
              Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).

       MDBICONV
              Defines the output charset to use for the SQL file. Default is  UTF-8.  mdbtools  must  have  been
              compiled with iconv.

       MDBOPTS
              Colon-separated list of options:

              •  debug_like

              •  debug_write

              •  debug_usage

              •  debug_ole

              •  debug_row

              •  debug_props

              •  debug_all is a shortcut for all debug_* options

              •  no_memo (deprecated; has no effect)

              •  use_index (experimental; requires libmswstr)

History

mdb-json first appeared in MDB Tools 0.9.

Name

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

Notes

Options

-D,--date-formatfmt
              Set the date format (see strftime(3) for details).

       -T,--time-formatfmt
              Set the date/time format (see strftime(3) for details).

       -U,--no-unprintable
              Change unprintable characters to spaces (otherwise escaped as \u00XX).

       --version
              Print the mdbtools version and exit.

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)

Synopsis

mdb-json [-Dfmt] [-Tfmt] [-U] databasetablemdb-json-h|--helpmdb-json--version

See Also