Version 4.47              First Published 07/12/2017             Last Updated 30/09/2022

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

Example Screenshots:

Main Form


File Analysis Form


JSON File Analysis (with File Hints)


File Analysis Report


Transform Function Code


JSON Table Output (with subdatasheets)


JSON File Summary Report


JATFA Summary Report


JATFA File Info & Hints Report


JSON File Analysis (with File Hints)


UPDATE - 15 May 2021:

I demonstrated this application at the virtual Access DevCon conference on 23rd April 2021. A video of the presentation is now available on You Tube at https://www.youtube.com/watch?v=zH6yUtsjrGQ or you can click below:


Version History

Version     Release Date     Info
v2.50         11/08/2017         free pre-release version with limited functionality
v4.20         17/12/2017         first commercial version
v4.47         28/09/2022         changes to explicitly handle content-type and x-access-token where needed

Purchase / Download

JSON Analyse & Transform for Access (JATFA) is available for purchase.

Click here to purchase the latest version (4.47).

Click here for further details about the program features (PDF file)

The application is particularly suitable for use by experienced Access developers

Each licence entitles you to install the application on 2 computers (business or personal).
Additional/site licenses can also be purchased if required

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

Anyone purchasing this application after 1 Sept 2022 will be entitled to a free copy of the next update planned for 2023

An older pre-release version of the program is also available at no cost to allow users to try out the application before committing to purchasing the full version.
The free pre-release application is a cut down version with fewer features

Click here to download the free pre-release version.

Colin Riddington           Mendip Data Systems                 Last Updated 30 Sept 2022

Return to Home Page

Return to Top