.\" Text automatically generated by txt2man
.TH mdb-json 1 "03 February 2024" "MDBTools 1.0.0" "Executable programs or shell commands"
.SH NAME
\fBmdb-json \fP- Export data in an MDB database table to JSON.
\fB
.SH SYNOPSIS
.nf
.fam C
\fBmdb-json\fP [\fB-D\fP \fIfmt\fP] [\fB-T\fP \fIfmt\fP] [\fB-U\fP] \fIdatabase\fP \fItable\fP
\fBmdb-json\fP \fB-h\fP|\fB--help\fP
\fBmdb-json\fP \fB--version\fP

.fam T
.fi
.fam T
.fi
.SH DESCRIPTION
\fBmdb-json\fP is a utility program distributed with MDB Tools. 
.PP
It produces a CSV (comma separated value) output for the given \fItable\fP. Such output is suitable for importation into databases or spreadsheets.
.SH OPTIONS
.TP
.B
\fB-D\fP, \fB--date-format\fP \fIfmt\fP
Set the date format (see \fBstrftime\fP(3) for details).
.TP
.B
\fB-T\fP, \fB--time-format\fP \fIfmt\fP
Set the date/time format (see \fBstrftime\fP(3) for details).
.TP
.B
\fB-U\fP, \fB--no-unprintable\fP
Change unprintable characters to spaces (otherwise escaped as \\u00XX).
.TP
.B
\fB--version\fP
Print the mdbtools version and exit.
.SH NOTES 

.SH ENVIRONMENT
.TP
.B
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See \fBiconv\fP(1).
.TP
.B
MDBICONV
Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
.TP
.B
MDBOPTS
Colon-separated list of options:
.RS
.IP \(bu 3
debug_like
.IP \(bu 3
debug_write
.IP \(bu 3
debug_usage
.IP \(bu 3
debug_ole
.IP \(bu 3
debug_row
.IP \(bu 3
debug_props
.IP \(bu 3
debug_all is a shortcut for all debug_* options
.IP \(bu 3
no_memo (deprecated; has no effect)
.IP \(bu 3
use_index (experimental; requires libmswstr)
.SH SEE ALSO
\fBmdb-array\fP(1) \fBmdb-count\fP(1) \fBmdb-export\fP(1) \fBmdb-header\fP(1) \fBmdb-hexdump\fP(1)
\fBmdb-import\fP(1) \fBmdb-parsecsv\fP(1) \fBmdb-prop\fP(1) \fBmdb-queries\fP(1)
\fBmdb-schema\fP(1) \fBmdb-sql\fP(1) \fBmdb-tables\fP(1) \fBmdb-ver\fP(1)
.SH HISTORY
\fBmdb-json\fP first appeared in MDB Tools 0.9.
.SH AUTHORS
The \fBmdb-json\fP utility was written by Ugo Di Girolamo. It is based on \fBmdb-export\fP(1).