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

FreeBSD Manual Pages

  
 
  

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

NAME
       mdb-json	- Export data in an MDB	database table to JSON.

SYNOPSIS
       mdb-json	[-D fmt] [-T fmt] [-U] database	table
       mdb-json	-h|--help
       mdb-json	--version

DESCRIPTION
       mdb-json	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
       -D, --date-format fmt
	      Set the date format (see strftime(3) for details).

       -T, --time-format fmt
	      Set the date/time	format (see strftime(3)	for details).

       -U, --no-unprintable
	      Change unprintable characters to spaces  (otherwise  escaped  as
	      \u00XX).

       --version
	      Print the	mdbtools version and exit.

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
	      Colon-separated list of options:

	      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

	      o	 no_memo (deprecated; has no effect)

	      o	 use_index (experimental; requires libmswstr)

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

HISTORY
       mdb-json	first appeared in MDB Tools 0.9.

AUTHORS
       The  mdb-json  utility  was  written by Ugo Di Girolamo.	It is based on
       mdb-export(1).

MDBTools 0.9.3		       21 September 2021		   mdb-json(1)

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | ENVIRONMENT | SEE ALSO | HISTORY | AUTHORS

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

home | help