GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
mdb-json(1) Executable programs or shell commands mdb-json(1)

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

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

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.

-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.

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:
  • debug_like
  • debug_write
  • debug_usage
  • debug_ole
  • debug_row
  • debug_props
  • debug_all is a shortcut for all debug_* options
  • no_memo (deprecated; has no effect)
  • use_index (experimental; requires libmswstr)

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)

mdb-json first appeared in MDB Tools 0.9.

The mdb-json utility was written by Ugo Di Girolamo. It is based on mdb-export(1).
12 April 2022 MDBTools 1.0.0

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.