Importing XML to database
Posted on 2007-10-15
I need a procedure which will import an XML file into a table.
Basically I want to loop through each node and if the node name matches a field in a table, I want it to import into the table using ADO into an access database). The problem I'm having is when I come across nodes which have a child, it tries to import all the data underneath the parent node into the table, when what I need it to do is check each of the child nodes, as they contain information which needs importing. How can I do this? I'm guessing that it may involve having a procedure which loops through the nodes and calls itself when it comes across a node which has a child? Hopefully I've explained this clearly enough - please ask me for more info should you require it.