mdb-export(1)

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

NAME

6       mdb-export - Export data in an MDB database table to CSV format.
7

SYNOPSIS

9       mdb-export [--no-header] [--delimiter delim] [--row-delimiter delim] [[--no-quote] | [--quote char [--escape char]]] [--escape-invisible] [--date-format fmt] [--datetime-format fmt] [--bin strip|raw|octal|hex] [--boolean-words] database table
10       mdb-export --insert backend [--namespace prefix] [--batch-size int] database table
11       mdb-export -h|--help
12       mdb-export --version
13
14

DESCRIPTION

16       mdb-export is a utility program distributed with MDB Tools.
17
18       It  produces  a CSV (comma separated value) output for the given table.
19       Such output is suitable for importation into databases or spreadsheets.
20
21       Used with --insert, it outputs SQL specific to backend dialect, includ‐
22       ing some constraints like NOT NULL and foreign keys.
23

OPTIONS

25       -H, --no-header
26              Suppress header row.
27
28       -d, --delimiter delim
29              Specify an alternative column delimiter. Default is , (comma).
30
31       -R, --row-delimiter delim
32              Specify a row delimiter. Default is \n (ASCII value 10).
33
34       -Q, --no-quote
35              Don't  wrap  text-like  fields (text, memo, date) in quotes.  If
36              not specified text fiels will be surrounded by " (double  quote)
37              characters.
38
39       -q, --quote char
40              Use char to wrap text-like fields. Default is " (double quote).
41
42       -X, --escape char
43              Use  char to escape quoted characters within a field. Default is
44              doubling.
45
46       -e, --escape-invisible
47              Use C-style escaping for return (\r), tab (\t), line-feed  (\n),
48              and back-slash (\\) characters. Default is to leave as they are.
49
50       -I, --insert backend
51              INSERT  statements  (instead of CSV). You must specify which SQL
52              backend dialect to use. Allowed values are: access, sybase, ora‐
53              cle, postgres, mysql and sqlite.
54
55       -N, --namespace prefix
56              Prefix identifiers with prefix.
57
58       -S, --batch-size int
59              Size of insert batches on supported platforms.
60
61       -D, --date-format fmt
62              Set the date format (see strftime(3) for details.
63
64       -T, --datetime-format fmt
65              Set the date/time format (see strftime(3) for details.
66
67       -0, --null char
68              Use  char  to  represent  a NULL value.  -b, --bin strip|raw|oc‐
69              tal|hex Binary export mode: strip binaries, export as-is, output
70              \ooo style octal data or output \xx style hexadecimal data.
71
72       -B, --boolean-words
73              Use TRUE/FALSE in Boolean fields (default is 0/1).
74
75       --version
76              Print the mdbtools version and exit.
77

NOTES

79       Most of the formatting options actually also works with --insert.
80

ENVIRONMENT

82       MDB_JET3_CHARSET
83              Defines  the charset of the input JET3 (access 97) file. Default
84              is CP1252. See iconv(1).
85
86       MDBICONV
87              Defines the output charset to use for the SQL file.  Default  is
88              UTF-8. mdbtools must have been compiled with iconv.
89
90       MDBOPTS
91              Colon-separated list of options:
92
93              •  debug_like
94
95              •  debug_write
96
97              •  debug_usage
98
99              •  debug_ole
100
101              •  debug_row
102
103              •  debug_props
104
105              •  debug_all is a shortcut for all debug_* options
106
107              •  no_memo (deprecated; has no effect)
108
109              •  use_index (experimental; requires libmswstr)
110

HISTORY

117       mdb-export first appeared in MDB Tools 0.1.
118

AUTHORS

120       The mdb-export utility was written by Brian Bruns.
121

BUGS

123       Memo  fields  are  allowed to contain a newline characters, the current
124       program does nothing about this.
125
126
127
128MDBTools 1.0.0                   20 July 2023                    mdb-export(1)