logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

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

Authors

       The mdb-import utility was written by Brian Bruns.

Bugs

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

MDBTools 1.0.1                                   05 January 2025                                   mdb-import(1)

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.

Environment

MDB_JET3_CHARSET
              Defines the charset of the JET3 (access 97) file. Default is CP1252. See iconv(1).

       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)

History

mdb-import first appeared in MDB Tools 0.7.

Name

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

Notes

Options

-H,--headerlines
              Skip lines of CSV header.

       -d,--delimiterchar
              Specify an alternative column delimiter. Default is , (comma).

       --version
              Print the mdbtools version and exit

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)

Synopsis

mdb-import [-Hlines] [-dchar] databasetablecsvfilemdb-import-h|--helpmdb-import--version

See Also