---
name: "mdb-json"
section: "1"
platform: "linux"
package: "mdbtools"
version: "1.0.1-0.1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/mdb-json"
---

# mdb-json(1)

Export data in an MDB database table to JSON.

## 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 JSON output for the given** *table***. Such output is suitable for parsing in a variety of languages.**

## OPTIONS

- **-D, --date-format *fmt***

  **Set the date format (see [strftime(3)](/strftime/3.md) for details).**

- **-T, --time-format *fmt***

  **Set the date/time format (see [strftime(3)](/strftime/3.md) 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)](/iconv/1.md).**

- **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)**

## SEE ALSO

**[mdb-array(1)](/mdb-array/1.md) [mdb-count(1)](/mdb-count/1.md) [mdb-export(1)](/mdb-export/1.md) [mdb-header(1)](/mdb-header/1.md) [mdb-hexdump(1)](/mdb-hexdump/1.md)** **[mdb-import(1)](/mdb-import/1.md) [mdb-parsecsv(1)](/mdb-parsecsv/1.md) [mdb-prop(1)](/mdb-prop/1.md) [mdb-queries(1)](/mdb-queries/1.md)** **[mdb-schema(1)](/mdb-schema/1.md) [mdb-sql(1)](/mdb-sql/1.md) [mdb-tables(1)](/mdb-tables/1.md) [mdb-ver(1)](/mdb-ver/1.md)**

## 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)](/mdb-export/1.md).**