Importing nested XML data

[Chris Doubleday]

I have an XML file to import into Access for reporting
purposes. It contains nested XML data - with the child
data nested under the parent data. It imports into two
distinct tables - "parent" and "child". Problem is there
is no key with which to join the two tables. Is there a
straightforward way to preserve the relationship that is
implied by the XML nesting, by having Access
automatically create the implied key?

Please advise & Thanks in advance.

Chris

 

[Joe Fallon]

Probably not.
But A2003 has the best shot at it since it is the most advanced in terms of
XML support.

One idea is to build the correcttables by hand.
Then import the XML to temp staging tables.
Then write queries to move data from staging tables to real tables.
I do this all the time for many file formats.