1mdb-json(1) Executable programs or shell commands mdb-json(1)
2
3
4
6 mdb-json - Export data in an MDB database table to JSON.
7
9 mdb-json [-D fmt] [-T fmt] [-U] database table
10 mdb-json -h|--help
11 mdb-json --version
12
13
15 mdb-json is a utility program distributed with MDB Tools.
16
17 It produces a CSV (comma separated value) output for the given table.
18 Such output is suitable for importation into databases or spreadsheets.
19
21 -D, --date-format fmt
22 Set the date format (see strftime(3) for details).
23
24 -T, --time-format fmt
25 Set the date/time format (see strftime(3) for details).
26
27 -U, --no-unprintable
28 Change unprintable characters to spaces (otherwise escaped as
29 \u00XX).
30
31 --version
32 Print the mdbtools version and exit.
33
36 MDB_JET3_CHARSET
37 Defines the charset of the input JET3 (access 97) file. Default
38 is CP1252. See iconv(1).
39
40 MDBICONV
41 Defines the output charset to use for the SQL file. Default is
42 UTF-8. mdbtools must have been compiled with iconv.
43
44 MDBOPTS
45 Colon-separated list of options:
46
47 • debug_like
48
49 • debug_write
50
51 • debug_usage
52
53 • debug_ole
54
55 • debug_row
56
57 • debug_props
58
59 • debug_all is a shortcut for all debug_* options
60
61 • no_memo (deprecated; has no effect)
62
63 • use_index (experimental; requires libmswstr)
64
66 mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1)
67 mdb-import(1) mdb-parsecsv(1) mdb-prop(1) mdb-queries(1) mdb-schema(1)
68 mdb-sql(1) mdb-tables(1) mdb-ver(1)
69
71 mdb-json first appeared in MDB Tools 0.9.
72
74 The mdb-json utility was written by Ugo Di Girolamo. It is based on
75 mdb-export(1).
76
77
78
79MDBTools 0.9.3 20 January 2022 mdb-json(1)