I am going to try and explain this the best I can and I hope everyone understands and can help.
*****I am not sure if in the XML file what I am referring to is called a Node, Boundary Tag, or Element. So I will call it a Node.****
I am importing a XML file into MS Access by VBA and when I do this Access separates the Children Nodes from the Parent Node and makes the Children Nodes tables and then puts the Grandchildren Nodes in the Children table as Field Names.
Here is a XML sample:
<?xml version="1.0" encoding="utf-8"?>
In my scenario here Access Makes these table:
So how can I get Access to either import all the Children and Grandchildren into a single table or how can I link these tables to show John Doe was OrderID 1234????
Thank you for the help?