I have an XML file that has multi-value fields. I am trying to convert this file to a relational database without success. The various techniques I have tried (reading the file directly into SQL Server & Access) both capture the structure but does not populate the data.

An option I am considering is to write some code to parse the XML file and generate the relational file. This raises a questions.

1) Does anyone have any suggestions, tips or know of sample code, possible with System.xml?

Any guidance would be appreciated.