Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help 
mdb-export(1)	     Executable	programs or shell commands	 mdb-export(1)

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

SYNOPSIS
       mdb-export [-H] [-d delim] [-R delim] [[-Q] | [-q char [-X char]]] [-I backend] [-D fmt]	[-N prefix] [-b	strip|raw|octal] database table
       mdb-export -h|--help

DESCRIPTION
       mdb-export is a utility program distributed with	MDB Tools.

       It  produces  a CSV (comma separated value) output for the given	table.
       Such output is suitable for importation into databases or spreadsheets.

OPTIONS
       -H, --no-header
	      Suppress header row.

       -Q, --no-quote
	      Don't wrap text-like fields (text, memo, date)  in  quotes.   If
	      not  specified text fiels	will be	surrounded by "	(double	quote)
	      characters.

       -d, --delimiter delim
	      Specify an alternative column delimiter. Default is , (comma).

       -R, --row-delimiter delim
	      Specify a	row delimiter. Default is (ASCII value 10).

       -I, --insert backend
	      INSERT statements	(instead of CSV). You must specify  which  SQL
	      backend dialect to use. Allowed values are: access, sybase, ora-
	      cle, postgres, mysql and sqlite.

       -D, --date-format fmt
	      Set the date format (see strftime(3) for details).

       -q, --quote char
	      Use to wrap text-like fields. Default is " (double quote).

       -X, --escape char
	      Use to escape quoted characters within a field. Default is  dou-
	      bling.

       -N, --namespace prefix
	      Prefix identifiers with prefix.

       -b, --bin strip|raw|octal
	      Binary  export  mode:  strip  binaries, export as-is, or output
	      style octal data.

NOTES
ENVIRONMENT
       MDB_JET3_CHARSET
	      Defines the charset of the input JET3 (access 97)	file.  Default
	      is CP1252. See iconv(1).

       MDBICONV
	      Defines  the  output charset to use for the SQL file. Default is
	      UTF-8. mdbtools must have	been compiled with iconv.

       MDBOPTS
	      semi-column separated list of options:

	      o	 use_index

	      o	 no_memo

	      o	 debug_like

	      o	 debug_write

	      o	 debug_usage

	      o	 debug_ole

	      o	 debug_row

	      o	 debug_props

	      o	 debug_all is a	shortcut for all debug_* options

SEE ALSO
       gmdb2(1)	mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1)  mdb-array(1)
       mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1) mdb-import(1)

HISTORY
       mdb-export first	appeared in MDB	Tools 0.1.

AUTHORS
       The mdb-export utility was written by Brian Bruns.

BUGS
       Memo  fields  are  allowed to contain a newline characters, the current
       program does nothing about this.

MDBTools 0.8.2			27 August 2020			 mdb-export(1)
NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | ENVIRONMENT | SEE ALSO | HISTORY | AUTHORS | BUGS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=mdb-export&sektion=1&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help