I wasn't active on this site when this thread was written and hadn't seen it until today
I have created a database to analyse and transform JSON files in Access.
It's now a commercial application aimed at developers so full code is supplied.
See this link for more details https://www.access-programmers.co.uk...d.php?t=295789
The thread also contains an early version with fewer features which you could have a look at to see if it looks useful.
Feel free to send me a PM or email me using the link in my signature line if you have any questions.