1mdb-json(1)          Executable programs or shell commands         mdb-json(1)
2
3
4

NAME

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

SYNOPSIS

9       mdb-json [-D fmt] [-T fmt] [-U] database table
10       mdb-json -h|--help
11       mdb-json --version
12
13

DESCRIPTION

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

OPTIONS

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

NOTES

ENVIRONMENT

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

SEE ALSO

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

HISTORY

71       mdb-json first appeared in MDB Tools 0.9.
72

AUTHORS

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                   23 March 2023                     mdb-json(1)
Impressum