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 [-H] [-d delimiter] [-R row_delim] [[-Q] | [-q quote [-X escape]]] [-I backend] [-D format] [-N namespace] [-b strip|raw|octal] database table
10
11

DESCRIPTION

13       mdb-export is a utility program distributed with MDB Tools.
14
15       It  produces  a CSV (comma separated value) output for the given table.
16       Such output is suitable for importation into databases or spreadsheets.
17

OPTIONS

19       -H     Supress header row
20
21       -Q     Don't wrap text-like fields (text, memo, date)  in  quotes.   If
22              not  specified text fiels will be surrounded by " (double quote)
23              characters.
24
25       -d     Specify an alternative column delimiter If no delimiter is spec‐
26              ified, table names will be delimited by a , (comma) character.
27
28       -R     Specify a row delimiter
29
30       -I backend
31              INSERT  statements  (instead of CSV). You must specify which SQL
32              backend dialect to use. Allowed values are: access, sybase, ora‐
33              cle, postgres, mysql and sqlite.
34
35       -D     Set the date format (see strftime(3) for details)
36
37       -q     Use to wrap text-like fields. Default is ".
38
39       -X     Use to escape quoted characters within a field.  Default is dou‐
40              bling.
41
42       -N namespace
43              Prefix identifiers with namespace.
44
45       -b strip|raw|octal
46              Binary export mode: strip binaries, export  as-is,  or  output
47              style octal data.
48

NOTES

ENVIRONMENT

51       MDB_JET3_CHARSET
52              Defines  the charset of the input JET3 (access 97) file. Default
53              is CP1252. See iconv(1).
54
55       MDBICONV
56              Defines the output charset to use for the SQL file.  Default  is
57              UTF-8. mdbtools must have been compiled with iconv.
58
59       MDBOPTS
60              semi-column separated list of options:
61
62              ·  use_index
63
64              ·  no_memo
65
66              ·  debug_like
67
68              ·  debug_write
69
70              ·  debug_usage
71
72              ·  debug_ole
73
74              ·  debug_row
75
76              ·  debug_props
77
78              ·  debug_all is a shortcut for all debug_* options
79

SEE ALSO

81       gmdb2(1)  mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1)
82       mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1)
83

HISTORY

85       mdb-export first appeared in MDB Tools 0.1.
86

AUTHORS

88       The mdb-export utility was written by Brian Bruns.
89

BUGS

91       Memo fields are allowed to contain a newline  characters,  the  current
92       program does nothing about this.
93
94
95
96MDBTools 0.7.1                   28 July 2020                    mdb-export(1)
Impressum