1untitled(January 31, 2006)                          untitled(January 31, 2006)
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] [-D <format>] [-S] <database> <table>
10

DESCRIPTION

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

OPTIONS

18       -H     Supress header row
19
20       -Q     Don't wrap text-like fields (text, memo, date)  in  quotes.   If
21              not  specified text fiels will be surrounded by " (double quote)
22              characters.
23
24       -d     Specify an alternative column delimiter If no delimiter is spec‐
25              ified, table names will be delimited by a , (comma) character.
26
27       -R     Specify a row delimiter
28
29       -I     INSERT statements (instead of CSV)
30
31       -D     Set the date format (see strftime(3) for details)
32
33       -S     Sanitize names (replace spaces etc. with underscore)
34
35       -q     Use to wrap text-like fields. Default is ".
36
37       -X     Use to escape quoted characters within a field.  Default is dou‐
38              bling.
39

NOTES

HISTORY
42       mdb-export first appeared in MDB Tools 0.1
43

AUTHORS
45       The mdb-export utility was written by Brian Bruns
46

BUGS
48       Memo fields are allowed to contain a newline  characters,  the  current
49       program does nothing about this.
50
51
52
53                                                    untitled(January 31, 2006)



        

    


            
        

        

            Impressum