MDB_JET3_CHARSET
Defines the charset of the JET3 (access 97) file. Default is CP1252. See iconv(1).
mdb-import1
Import csv data into an mdb database.
Usage
mdb-import [-H
lines]
[-d
char]
database
table
csvfile
mdb-import {-h | --help}
mdb-import --version
Overview
mdb-import is a utility program distributed with MDB Tools.
It reads a CSV (comma separated value) file and add the data into table of database.
Options
-
-H, --header lines -
Skip lines of CSV header.
-
-d, --delimiter char -
Specify an alternative column delimiter. Default is , (comma).
-
--version -
Print the mdbtools version and exit
Notes
Environment
-
MDBICONV -
Defines the input charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
-
MDBOPTS -
Colon-separated list of options:
- •
-
debug_like
- •
-
debug_write
- •
-
debug_usage
- •
-
debug_ole
- •
-
debug_row
- •
-
debug_props
- •
-
debug_all is a shortcut for all debug_* options
- •
-
no_memo (deprecated; has no effect)
- •
-
use_index (experimental; requires libmswstr)
Releases
3 releases since Debian 11 (Bullseye); the text changed 2 times.
--version since Debian 12 (Bookworm).