.\" Text automatically generated by txt2man
.TH mdb-import 1 "10 March 2024" "MDBTools 1.0.0" "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
\fBmdb-import\fP \fB--version\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).
.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 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
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-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.