thank you - I did try this and it does work for a basic XML file i.e. I can successfully load a file that I created.
The issue is that the XML file comes from another system and I believe it needs to be parsed. From my searching it appears this can be done using MSXML, however I cannot seem to get it working in Access. I suspect I need a library reference loaded but not sure which one I need.
When I put the following statement into my procedure:
Dim oDoc As MSXML.DOMDocument
I get an error saying User Defined Type not defined.
@ADezii