.\" Text automatically generated by txt2man
.TH mdb-export 1 "22 March 2018" "MDBTools 0.7.1" "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-H\fP] [\fB-d\fP \fIdelimiter\fP] [\fB-R\fP \fIrow_delim\fP] [[\fB-Q\fP] | [\fB-q\fP \fIquote\fP [\fB-X\fP \fIescape\fP]]] [\fB-I\fP \fIbackend\fP] [\fB-D\fP \fIformat\fP] [\fB-N\fP \fInamespace\fP] [\fB-b\fP strip|raw|octal] \fIdatabase\fP \fItable\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.
.SH OPTIONS
.TP
.B
\fB-H\fP
Suppress header row
.TP
.B
\fB-Q\fP
Don't wrap text-like fields (text, memo, date) in quotes.  If not specified text fiels will be surrounded by " (double \fIquote\fP) characters.
.TP
.B
\fB-d\fP
Specify an alternative column \fIdelimiter\fP If no \fIdelimiter\fP is specified, \fItable\fP names will be delimited by a , (comma) character.
.TP
.B
\fB-R\fP
Specify a row \fIdelimiter\fP
.TP
.B
\fB-I\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-D\fP
Set the date \fIformat\fP (see \fBstrftime\fP(3) for details)
.TP
.B
\fB-q\fP
Use to wrap text-like fields. Default is ".
.TP
.B
\fB-X\fP
Use to \fIescape\fP quoted characters within a field.  Default is doubling.
.TP
.B
\fB-N\fP \fInamespace\fP
Prefix identifiers with \fInamespace\fP.
.TP
.B
\fB-b\fP strip|raw|octal
Binary export mode: strip binaries, export as-is, or output \ooo style octal data.
.RE
.PP

.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
semi-column separated list of options:
.RS
.IP \(bu 3
use_index
.IP \(bu 3
no_memo
.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
.SH SEE ALSO
\fBgmdb2\fP(1) \fBmdb-hexdump\fP(1) \fBmdb-prop\fP(1) \fBmdb-sql\fP(1) \fBmdb-ver\fP(1) \fBmdb-array\fP(1)
\fBmdb-header\fP(1) \fBmdb-parsecsv\fP(1) \fBmdb-schema\fP(1) \fBmdb-tables\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.