Automation between Ms Access and Json

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™
on
Hi

I know we have a good number of experts here and very experienced, now I need guidance on the VBA function that can retrieve the data from Json format like below:
{
"code": "500",
"Naration": "OK",
"declared-info": {
"Receipt-code": "3333333",
"Receipt-number": "111111",
"Customer-ID": "1025360",
"Customer-vat ": "78963102",
{

I hope you can see the parameters above, the VBA function when run need to grab the data from those parameters from the point of sales machine (POS). The accomplishment here is to ensure that the receipts that are created from the POS machines are not recaptured into Ms Access Application , instead they must be automated to avoid errors, this is the requirement by our client of which we do agree the concept.

Regards

Chris
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
Have you seen: https://github.com/VBA-tools/VBA-JSON which can convert and parse JSON through VBA, should be what you are looking for.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial