Can Access 2000 import XML Data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been given some data in XML format which I need to import in to Access
2000. I know that Access 2002 can handle XML. but I can not seem to find out
how Import XML into 2000.
 
To the best of my knowledge, the only built-in support for XML available
when using Access 2000 is the ability to save and open an ADO recordset
to/from an XML file. If you want to pursue this option, check out KB article
263247, "HOWTO: Obtain an ADO Recordset from XML".

I encountered what appears to be a bug where ADO will not correctly return
all records when the XML file uses the non-abbreviated format for empty
elements (<z:row ...></z:row>). I had to replace it with the abbreviated
format (<z:row ... />)

Alternatively, if you ask around in the XML/XSL newsgroups, someone might be
able to advise you on how to transform the XML into a format that the
built-in import tools would recognize, such as CSV or fixed-width.
 
I agree.
I had to write my own XML import routine for A97 and 2000.
It was a bit of a hack, but it worked.

I strongly recommend upgrading to the lates version if you need XML support.
 
Thank you Brendan,

I'll look into the KB to see if I can get something going.

Thanks again,

Matt
 
Back
Top