1mdb-import(1) Executable programs or shell commands mdb-import(1)
2
3
4
6 mdb-import - Import CSV data into an MDB database.
7
9 mdb-import [-H lines] [-d char] database table csvfile
10 mdb-import -h|--help
11 mdb-import --version
12
13
15 mdb-import is a utility program distributed with MDB Tools.
16
17 It reads a CSV (comma separated value) file and add the data into table
18 of database.
19
21 -H, --header lines
22 Skip lines of CSV header.
23
24 -d, --delimiter char
25 Specify an alternative column delimiter. Default is , (comma).
26
27 --version
28 Print the mdbtools version and exit
29
32 MDB_JET3_CHARSET
33 Defines the charset of the JET3 (access 97) file. Default is
34 CP1252. See iconv(1).
35
36 MDBICONV
37 Defines the input charset to use for the SQL file. Default is
38 UTF-8. mdbtools must have been compiled with iconv.
39
40 MDBOPTS
41 Colon-separated list of options:
42
43 • debug_like
44
45 • debug_write
46
47 • debug_usage
48
49 • debug_ole
50
51 • debug_row
52
53 • debug_props
54
55 • debug_all is a shortcut for all debug_* options
56
57 • no_memo (deprecated; has no effect)
58
59 • use_index (experimental; requires libmswstr)
60
62 mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1)
63 mdb-json(1) mdb-parsecsv(1) mdb-prop(1) mdb-queries(1) mdb-schema(1)
64 mdb-sql(1) mdb-tables(1) mdb-ver(1)
65
67 mdb-import first appeared in MDB Tools 0.7.
68
70 The mdb-import utility was written by Brian Bruns.
71
73 mdb-import does not enforce any kind of checks. You can violate con‐
74 straints.
75
76
77
78MDBTools 0.9.3 20 January 2022 mdb-import(1)