1mdb-import(1)        Executable programs or shell commands       mdb-import(1)
2
3
4

NAME

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

SYNOPSIS

9       mdb-import [-H lines] [-d char] database table csvfile
10       mdb-import -h|--help
11       mdb-import --version
12
13

DESCRIPTION

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

OPTIONS

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

NOTES

ENVIRONMENT

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

SEE ALSO

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

HISTORY

67       mdb-import first appeared in MDB Tools 0.7.
68

AUTHORS

70       The mdb-import utility was written by Brian Bruns.
71

BUGS

73       mdb-import does not enforce any kind of checks. You  can  violate  con‐
74       straints.
75
76
77
78MDBTools 1.0.0                   20 July 2023                    mdb-import(1)
Impressum