.\" Text automatically generated by txt2man
.TH mdb-export 1 "03 February 2024" "MDBTools 1.0.0" "Executable programs or shell commands"
.SH NAME
\fBmdb-export \fP- Export data in an MDB database table to CSV format.
\fB
.SH SYNOPSIS
.nf
.fam C
\fBmdb-export\fP [\fB--no-header\fP] [\fB--delimiter\fP \fIdelim\fP] [\fB--row-delimiter\fP \fIdelim\fP] [[\fB--no-quote\fP] | [\fB--quote\fP \fIchar\fP [\fB--escape\fP \fIchar\fP]]] [\fB--escape-invisible\fP] [\fB--date-format\fP \fIfmt\fP] [\fB--datetime-format\fP \fIfmt\fP] [\fB--bin\fP strip|raw|octal|hex] [\fB--boolean-words\fP] \fIdatabase\fP \fItable\fP
\fBmdb-export\fP \fB--insert\fP \fIbackend\fP [\fB--namespace\fP \fIprefix\fP] [\fB--batch-size\fP \fIint\fP] \fIdatabase\fP \fItable\fP
\fBmdb-export\fP \fB-h\fP|\fB--help\fP
\fBmdb-export\fP \fB--version\fP

.fam T
.fi
.fam T
.fi
.SH DESCRIPTION
\fBmdb-export\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.
.PP
Used with \fB--insert\fP, it outputs SQL specific to \fIbackend\fP dialect, including some constraints like NOT NULL and foreign keys.
.SH OPTIONS
.TP
.B
\fB-H\fP, \fB--no-header\fP
Suppress header row.
.TP
.B
\fB-d\fP, \fB--delimiter\fP \fIdelim\fP
Specify an alternative column delimiter. Default is , (comma).
.TP
.B
\fB-R\fP, \fB--row-delimiter\fP \fIdelim\fP
Specify a row delimiter. Default is \\n (ASCII value 10).
.TP
.B
\fB-Q\fP, \fB--no-quote\fP
Don't wrap text-like fields (text, memo, date) in quotes.  If not specified text fiels will be surrounded by " (double quote) characters.
.TP
.B
\fB-q\fP, \fB--quote\fP \fIchar\fP
Use \fIchar\fP to wrap text-like fields. Default is " (double quote).
.TP
.B
\fB-X\fP, \fB--escape\fP \fIchar\fP
Use \fIchar\fP to escape quoted characters within a field. Default is doubling.
.TP
.B
\fB-e\fP, \fB--escape-invisible\fP
Use C-style escaping for return (\\r), tab (\\t), line-feed (\\n), and back-slash (\\\\) characters. Default is to leave as they are.
.TP
.B
\fB-I\fP, \fB--insert\fP \fIbackend\fP
INSERT statements (instead of CSV). You must specify which SQL \fIbackend\fP dialect to use. Allowed values are: access, sybase, oracle, postgres, mysql and sqlite.
.TP
.B
\fB-N\fP, \fB--namespace\fP \fIprefix\fP
Prefix identifiers with \fIprefix\fP.
.TP
.B
\fB-S\fP, \fB--batch-size\fP \fIint\fP
Size of insert batches on supported platforms.
.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--datetime-format\fP \fIfmt\fP
Set the date/time format (see \fBstrftime\fP(3) for details.
.TP
.B
\fB-0\fP, \fB--null\fP \fIchar\fP
Use \fIchar\fP to represent a NULL value.
\fB-b\fP, \fB--bin\fP strip|raw|octal|hex Binary export mode: strip binaries, export as-is, output \\ooo style octal data or output \\xx style hexadecimal data.
.TP
.B
\fB-B\fP, \fB--boolean-words\fP
Use TRUE/FALSE in Boolean fields (default is 0/1).
.TP
.B
\fB--version\fP
Print the mdbtools version and exit.
.SH NOTES 
Most of the formatting options actually also works with \fB--insert\fP.
.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-header\fP(1) \fBmdb-hexdump\fP(1)
\fBmdb-import\fP(1) \fBmdb-json\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-export\fP first appeared in MDB Tools 0.1.
.SH AUTHORS
The \fBmdb-export\fP utility was written by Brian Bruns.
.SH BUGS
Memo fields are allowed to contain a newline characters, the current program does nothing about this.