Import XML data into MS Access2000

[Guest]

I would like to import data into MS Access2000.
There does not appear to be any drivers available to do this.
It works terrifically well in MS Access 2003.
Most of our machines are using MS Access 2000, and we will upgrade at the
end of the year.
We would like to implment an import routine of XML data using MS Access 2000
until such time that we upgrade.
Any suggestions ? are there special custom ODBC drivers that can be
purchased ?
Thank you,

 

[Brendan Reynolds]

You can open an ADO recordset on an XML file, but the file must be in the
specific schema that is recognised by the ADO recordset. If the file is not
already in that schema, you'll need to use XSLT to transform it.
Alternatively, you can open the XML file as a text file, and write your own
code to parse it.

Here's a link to a previous discussion about reading XML via ADO in the
Google
archives. Toward the end of that discussion, there's also a link to a
related KB article. The code in the newsgroup discussion is in C#, but the
KB article uses VB.NET.

The newsgroup discussion ...

http://tinyurl.com/qr3yn

The KB article ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;316337

 

[Guest]

Thank you, Brendan. I'll have a look at the website.
Cheers.