reading XML data

[Ray Gurganus]

I have an XML file, and trying to convert it into a database table. I first
tried the MS Access import option, but it doesn't read into the nested XML
properties, and so I lose data this way. So my next idea is to read through
it line by line, extracting out the data and then inserting into the table.
Is there a more intelligent way to do this VB? So I could read one XML tag
and then reference it's children as properties, something like the fields()
collection of a recordset? Other ideas?

 

[Joe Fallon]

1. Did you try A2003? It has the best support for XML of any version.
(Obviously.)

2. You can write code use the DOM and parse it yourself.
Not very easy.
I wrote one once and it took a few days to debug everything.