Scroll to navigation

mdb-import(1) Executable programs or shell commands mdb-import(1)

NAME

mdb-import - Import CSV data into an MDB database.

SYNOPSIS

mdb-import [-H lines] [-d char] database table csvfile
mdb-import -h|--help
mdb-import --version

DESCRIPTION

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

Skip lines of CSV header.
Specify an alternative column delimiter. Default is , (comma).
Print the mdbtools version and exit

NOTES

ENVIRONMENT

Defines the charset of the JET3 (access 97) file. Default is CP1252. See iconv(1).
Defines the input charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
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)

SEE ALSO

mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1) mdb-json(1) mdb-parsecsv(1) mdb-prop(1) mdb-queries(1) mdb-schema(1) mdb-sql(1) mdb-tables(1) mdb-ver(1)

HISTORY

mdb-import first appeared in MDB Tools 0.7.

AUTHORS

The mdb-import utility was written by Brian Bruns.

BUGS

mdb-import does not enforce any kind of checks. You can violate constraints.

03 April 2023 MDBTools 1.0.0