Purchase Software

JSON Analyse & Transform for Access (JATFA)

£75.00 GBP

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

Features include:
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)