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.
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.
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.
What is left behind
Access queries, forms and reports are left out. Only the tables are converted.
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
Access Database
Microsoft Access databases with several tables inside.
- Extensions
- .mdb .accdb
- MIME type
- application
/x -msaccess - Kind
- Text and data
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.
$ cv convert report.mdb report/ --to json$ cv convert report.mdb report/ --to jsonQuestions.What people ask about MDB to JSON.
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.