Increasingly, a wide range of online data is being supplied as JSON files.

The file format is very versatile and efficient allowing rapid data transfer

 

However, Access does not currently provide an easy method of working with JSON files.

 

JSON Analyse & Transform for Access (JATFA) has been designed to make importing and handling JSON files 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 sample JSON files are supplied as examples

 

The application may be installed on 2 computers.

Additional/site licenses can also be purchased if required

 

The application is particularly suitable for use by Access developers

 

Full program code and 90 days email support are included with the application