JsonToAccess 1.6 Released Download
2018/03/19
V1.6 Released
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.
Improve JSON source view.
Improve read TAB, break line in JSON file.

2017/12/01
V1.5 Released
Add view TEXT(CLOB) by mouse click.
Fix import string contains single quote.
Fix load data to ftVarBytes field.
Improve read JSON ISODate.
Improve read JSON array.
Improve support to read big JSON file.

2017/04/18
V1.4 Released
Add "move successful files to another folder" function.
Add check file path exists before create Access file.
Add convert data from web.
Add handle for skip rows big than total rows.
Add support date format like: "20150101 13:43:29".
Add support date format like: "2016-04-12T18:37:09-07:00".
Add support date format like: "2016-07-21T17:18:52Z".
Add support date format like: "Fri, 21 Oct 2016 13:08:32 +0800".
Add support date formats like: "2015:06:21", "2015:06:21 08:02:48", "2016:03:20 20:08:08-06:00".
Add support to array of array.
Add support to convert from n sub-level JSON child nodes.
Add view target table after importing.
Fix bug on source data file name has no ext.

2016/11/11
V1.3 Released
Add "Import ISODate".
Add "Show table DDL".
Fix import date with format "YYYYMM".
Fix import date/integer/float/bool data bug when data is "N/A".
Improve wizard form UI.

2016/08/18
V1.2 Released
Add "Create Table" on right click menu.
Add "Database Object TreeView".
Add "Drop Table" on right click menu.
Add "View Table Data" on right click menu.
Add "View Table Struct" on right click menu.

2016/07/21
V1.1 Released
Add field name length limit on creating table.
Add support importing data from MongoDB exported JSON data file.
Add support importing data to field that field name contains "~".
Add support to more number formats.
Adjust login form.
Fix bug caused by key constains whitespace.
Improve command line, made it more simple.
Improve parsing date format.
Improve parsing number format.

2016/03/02
V1.0 Released