I'm not an Excel person, so the code you found may be the answer or at least an answer. Can you take 1 or 2 of your 20+ files and show us a database (or describe the scenario) that goes from a "json" file (simulated response) through to some Access table or process?
That's what I did in post #13
I used your JSON file & imported into Excel using PowerQuery then did a standard import into Access. Both Excel & Access files were attached to that post
There's no code involved at all.
The PowerQuery addin for 2010/2013 does all the work.
In Excel 2016 its called Get&Transform.
If you have 2007 or earlier, sorry but you're stuffed
As for the 'how', I followed the method used in the video (see link in same post) but using Excel 2010.
I then repeated the process with some SMS messaging data using my Twilio account & various other JSON files emailed to me by
@ashleedawg
If you post another example JSON file, I'm happy to repeat & post the results.
I could post another example of mine or ashleedawg's (with his agreement) if it helps, but the video explains how to do it better than I can put it in words.
Alternatively perhaps we could set up a remote session at an agreed time using Teamviewer so I could show you. As I'm in the UK, I'm several hours 'ahead' of you.