Convert MDB to JSON

Turn MDB files into JSON files. One JSON file per table, named after it: an array with one object per row, with numbers and nulls typed.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop MDB files on the dialor turn it to pick what to do

One JSON file for each table.Each table in your Access database becomes its own JSON file, named after the table.

  1. What you get

    Every file holds an array with one object per row. Numbers and nulls are typed, so a number is a number and an empty value is null.

    Both MDB and ACCDB files are read. A database with several tables gives you several files.

  2. What changes

    Dates are written as text in the form YYYY-MM-DD hh:mm:ss. Yes/no fields are written as 1 and 0.

  3. What is left behind

    Access queries, forms and reports are left out. Only the tables are converted.

  4. When it fails

    If the file could not be parsed, the conversion stops with input_corrupted.

MDB and JSON.What each format is.

The formats

From · MDB

Access Database

Microsoft Access databases with several tables inside.

Extensions
.mdb .accdb
MIME type
application/x-msaccess
Kind
Text and data
To · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

In your code.The same MDB to JSON conversion through the API, for your app or your agent.

terminal
$ cv convert report.mdb report/ --to json
$ cv convert report.mdb report/ --to json

Questions.What people ask about MDB to JSON.

01OF 04

Yes. Each table becomes one JSON file named after the table. Each file holds an array with one object per row.

Dates are written as text in the form YYYY-MM-DD hh:mm:ss.

No. These are left out. Only the tables are converted.

Yes. Both the mdb and accdb extensions are accepted as input.

More conversions.Other ways in and out of MDB and JSON.