Greetings Experts,
I am cycling through a directory containing .xml files which I then import into tables making use of the
Application.ImportXML method. However, not all data within each .xml file are being imported. After
some searching I discovered that the mentioned method I am using only imports "element-centric content" and
not "attribute-centric content".
There are suggestions the the .xml files must be transformed to move attributes to elements with "XLST" (Don't know what that is?) prior
to importing the data.
I am fairly experienced with MS Access VBA; but have no experience when it comes to the importing of .xml files and
how to do the abovementioned/suggested transformation.
Any assistance (hopefully with sample code) would be hugely welcomed and appreciated. I have attached one of the .xml
files as reference as well as the Access Tables generated via the abovementioned method. You will notice that there are a significant
amount of data in the .xml file that's not being imported into the Access Tables.
Thanking you for your time.