Question How to Process Large XML File

[RibTime]

Hi there

Quite new to VB.net and looking for advice on how to process large XML files. The file I have is about 600mb but could be larger and I want to load it into a Access database.

Using the import feature of Access doesn't load the data correctly, for instance I have

<owner_data>
<name>john</name>
<child_name>jack</child_name>
<child_name>jill</child_name>
</owner_data>

This isn't anything like my data but you should get the idea I have multiple <child_name> tags and when using Access import it creates multiple tables.

Currently in my VB code I use...

    Dim ds As New DataSet("XMLDataSet")
        Dim xmlDocument As New XmlDocument
        Dim XmlNodelist As XmlNodeList
        Dim xmlNode As XmlNode

        xmlDocument = New XmlDocument

        Debug.WriteLine("About to load VXML file " & DateTime.Now)

        xmlDocument.Load(xmlFile)

Later on in my code I manipulate the <child_name> tags into "child_1", "child_2" etc etc to maintain a single table entry.

But it fails with "A first chance exception of type 'System.OutOfMemoryException' occurred in mscorlib.dll" during the ".Load", which I assume is related to the file size.

Looking for recommendations a different method to process / manipulate large XML files.

Thanks in advance.