Importing XML-files

[RoyVidar]

I'm doing sequential read from the file, sorting out the different fields, quotes, tags and whatever. Are there any tools for a more dynamic way of importing XML-files in A-2000?<br><br>Any help would be appreciatet.

 

[DougP]

Can you put a &quot;small&quot; copy of the XML file here to look at <br>It's ASCII text right?<br>Doesn't the first part of the file tell the field story.<br><br>I thought I heard Access 2000 was going to have XML capabilities. I Tried to look it up in Help and got nothing. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[DougP]

here is something on Microsofts WEB site<br><br><A HREF="

http://msdn.microsoft.com/xml/default.asp"

TARGET="_new">

http://msdn.microsoft.com/xml/default.asp</A>

<p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[RoyVidar]

Thank you for your answer. I also had the impression prior to starting this project, that some part of the file should tell the field story. I.e when you save a persistent recordsets through VBA as xml (rst.Save strFile, adPersistXML), in my case you get to full pages (notepad) with schema information, field types, names, precision etc before any data. But not in this file. <br><br>Here is a sample showing what one record might look like. There's a total of 17 fields were some are transferred every time, others only occasionally. <br><br>I think I'll continue sequential read;-). <br><br>&quot;<br>&lt;?xml version=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot; ?&gt;<br><br>&lt;itemlist type=&quot;snapshot&quot;&gt;<br><br>&lt;time&gt;<br> &lt;date tz=&quot;MET&quot;&gt;14/06 2000 16:00:03&lt;/date&gt;<br>&lt;/time&gt;<br><br>&lt;quote&gt;<br> &lt;field1&gt;NO1234567890&lt;/field1&gt;<br> &lt;field2&gt;Code&lt;/field2&gt;<br> &lt;field3&gt;Name&lt;/field3&gt;<br> &lt;field5&gt;2,00&lt;/field5&gt; <br> &lt;date tz=&quot;MET&quot; type=&quot;date&quot; field=&quot;last&quot;&gt;15/05-00&lt;/date&gt;<br> &lt;field9&gt;19.992.000&lt;/field9&gt;<br> &lt;field11&gt;39.984.000,00&lt;/field11&gt;<br>&lt;/quote&gt;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;... and N records;-)&quot;<br><br>&lt;/itemlist&gt;<br>&quot;<br>