import xml

[zezo2021]

is there any way to automate importing XML for beginner user

I want to use the VBA Code

Because I want to hide the ribbon

External data > import and link > XML

 

[ebs17]

Application.ImportXML method (Access)

Office VBA reference topic

learn.microsoft.com

For a correct and usable import, I don't just look at the exchange file. First and foremost is the database schema of my backend. This should be thought out and completed.

For me, import means that all the information is in the right place and can therefore be used immediately for my subsequent analysis. There's just no real success in it somehow.

 

[arnelgp]

open Form1 from the sample db and use it on your 2 xml file to import.
see the VBA on Module1 and of the Form1.

 

[zezo2021]

open Form1 from the sample db and use it on your 2 xml file to import.
see the VBA on Module1 and of the Form1.

 

[zezo2021]

@arnelgp

@arnelgp

can you please give a solution to import JSON also?

I tried but did not succeed

attached sample file of what I want to import


thank you so much for the great help

appreciated

Solved - import json

Why this code not work I do all the steps Add reference and module attache all code and reference the db with code json file

www.access-programmers.co.uk

 

[arnelgp]

you can try to plug the file to the VBA in the excel file on this thread:
Help with JSON parse | Access World Forums (access-programmers.co.uk)