import xml into db and create tables

[aaron.kempf]

I would like to find a tool that will take complex XML documents and
translate them into a database...

I would like it to create relationships between nodes; entities;
attributes; etc

I've used MS Access for some of this but it is kinda buggy.. it just
seems like it only hits half the fields

any ideas for a 3rd party product?

-Aaron

 

[Joseph Kesselman]

May be overkill for your needs, but IBM's DB2 not only has tools to
import XML into relational tables and export tables to XML, but the most
recent version adds a hierarchical data model specifically for XML-based
processing.