Increasingly, data is supplied from online sources as JSON files.
The file format is very versatile and efficient allowing rapid data transfer
However, the data then needs to be processed (parsed) before it can be used in Access. Unfortunately, Access does not provide a method for importing JSON files easily. The issue is compounded by the fact that each JSON file has a unique and often complex structure
JSON Analyse & Transform for Access (JATFA) was designed to overcome these issues. Importing and handling JSON files becomes a straightforward and, in many cases, a largely automated task
a) Fully automated analysis of JSON files including handling of subarrays
b) Fully automated creation of tables and transform functions based on file analysis.
c) Import JSON data into normalised Access tables based on file analysis
d) Over 90 JSON files are supplied as examples.
Full program code and 90 days email support are included
The licence entitles you to install the application on two workstations (personal or business).
This software may NOT be used in commercial applications without the permission of Isladogs on Access (Mendip Data Systems)