.\" Text automatically generated by txt2man
.TH mdb-import 1 "04 January 2021" "MDBTools 0.9.1" "Executable programs or shell commands"
.SH NAME
\fBmdb-import \fP- Import CSV data into an MDB database.
\fB
.SH SYNOPSIS
.nf
.fam C
\fBmdb-import\fP [\fB-H\fP \fIlines\fP] [\fB-d\fP \fIchar\fP] \fIdatabase\fP \fItable\fP \fIcsvfile\fP
\fBmdb-import\fP \fB-h\fP|\fB--help\fP

.fam T
.fi
.fam T
.fi
.SH DESCRIPTION
\fBmdb-import\fP is a utility program distributed with MDB Tools. 
.PP
It reads a CSV (comma separated value) file and add the data into \fItable\fP of \fIdatabase\fP.
.SH OPTIONS
.TP
.B
\fB-H\fP, \fB--header\fP \fIlines\fP
Skip \fIlines\fP of CSV header.
.TP
.B
\fB-d\fP, \fB--delimiter\fP \fIchar\fP
Specify an alternative column delimiter. Default is , (comma).
.SH NOTES 

.SH ENVIRONMENT
.TP
.B
MDB_JET3_CHARSET
Defines the charset of the JET3 (access 97) file. Default is CP1252. See \fBiconv\fP(1).
.TP
.B
MDBICONV
Defines the input 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
\fBmdb-array\fP(1) \fBmdb-count\fP(1) \fBmdb-export\fP(1) \fBmdb-header\fP(1) \fBmdb-hexdump\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-import\fP first appeared in MDB Tools 0.7.
.SH AUTHORS
The \fBmdb-import\fP utility was written by Brian Bruns.
.SH BUGS
\fBmdb-import\fP does not enforce any kind of checks. You can violate constraints.