reading XML data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ray Gurganus (rgurganus_at_--NOSPAM--citidc.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 13:43:38 -0400

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?

Relevant Pages

  • Re: XML parser and writer
    ... them on a calendar. ... Therefore I will need to both easily parse and write new XML files. ... why not some database technology? ... an advanced user can edit the XML file directly at ...
    (comp.lang.java.programmer)
  • Re: adodb.recordset.save and back
    ... Rinoo Rajesh wrote: ... > persisted XML file back into recordset, ... and when you reconnect it to the database you get the error ...
    (microsoft.public.data.ado)
  • Re: Special Characters not resolving
    ... starting data at the origin in an ORacle database is 2000 characters. ... When the XML isdelivered to me on disk and I load an ... Obviously I need to find either a way to have the XML file provider strip ...
    (microsoft.public.dotnet.xml)
  • Re: dynamic class instantiation
    ... I think mixing XML, ... LDF to python parser is a LOT ... This xml file is then fed into the database at the ...
    (comp.lang.python)
  • Re: XML and the Datagrid
    ... I find it, when it is in memory, exactly as good as the database, because it ... I wished that the complexity from an XML file was in a real database system. ... It is in my opinion the best thing to describe and hold data until now and I ...
    (microsoft.public.dotnet.languages.vb)