reading XML data

  • Thread starter Thread starter Ray Gurganus
  • Start date Start date
R

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?
 
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.
 
Back
Top