This is a simple console application that can dump data from a Microsoft Access database to JSON. It can also display some metadata about the tables and columns in the database.
The application supports two verbs, info and json. You can also use the verb help to list the supported options.
Two options are common for both the info and the json verbs
| option | description |
|---|---|
--database |
the path to Access database file |
--password |
password of the database, if it is protected |
The info verb displays metadata about the tables in the database.
Options
| option | description |
|---|---|
-t, --table |
display info about a specific table |
Examples
Dump meta data about all tables in the database:
access2json info --database phonebook.mdbDisplay metadata about the Address table:
access2json info --database phonebook.mdb --table AddressGenerates JSON from the data in the database. There are a few options you can use to customize the output
Options
| option | description |
|---|---|
-t, --tables |
Dump data from these tables. Separate names with a comma. Default is to dump all tables. |
-o, --out-file |
A file path. Write the resulting JSON to this file. The default is to write output to standard out. |
--pretty |
Indent the JSON output nice and pretty. The default is one line |
--normalize |
Try to make property names usable via dot notation by removing diacritics and replacing non-identifier characters with underscores. |
--force-numbers |
If a string value from the database looks like a number, cast it to a number in the output |
--keep-text |
Comma separated property names that will be kept as text no matter what |
Examples
Write data from the Address table to, nicely indented, with normalized property names and all numberlike strings cast to numbers to a file named address.json
access2json json --database phonebook.mdb -t Address --pretty --normalize --force-numbers > address.jsonDump all data of the protected database to the file dump.js
access2json json --database phonebook.mdb --password 123456 --out-file c:\users\john\dump.js If you get an error when running the application that says something like The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine, you probably don't have an Access db engine installed. Follow these instructions to get that stuff installed.