Reading in XML with Access 2000

[Guest]

I have a number of XML files (about 30), that I would like to Access to read
and put into a table.
I then want to be able to select out the various tokens.

XML does not seem to be one of the input data types - so any udeas on how to
read the files?

Gary

 

[Brendan Reynolds]

If you're using Access 2003, see the URLs I posted in the 'Outputting to
XML' thread. If you're using a different version, which version is it?

 

[Guest]

I'm using Access 2000 -----------/\
Gary

If you're using Access 2003, see the URLs I posted in the 'Outputting to
XML' thread. If you're using a different version, which version is it?

 

[Brendan Reynolds]

Unfortunately, the only XML support in Access 2000 is the ability to open an
ADO recordset using an XML file as the source, and the XML file has to use a
specific schema - the same schema used when an ADO recordset is saved to an
XML file. It's possible to use XSLT to transform XML from a different schema
into the schema required by ADO, but it is decidedly non-trivial. Check out
the following KB articles ...

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

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

And also this post in the Google archives concerning my own struggles with
this issue, and a work-around to one of the problems ...

http://groups.google.com/group/microsoft.public.data.ado/msg/88b9fac14b98d746

The work-around was pretty ugly, and I ended up doing it a different way,
using regular expressions, but that was in C#, not VBA ...

http://groups.google.com/group/microsoft.public.xml/msg/ad5cd1771edd1c84

You might want to consider checking out the XML support in later versions of
Access. If it looks like those features will meet your needs, an upgrade
might be a simpler solution than trying to make it work in Access 2000.
Here's a link to an MSDN article on XML in Access 2003 ...

http://msdn.microsoft.com/office/un...c_ac2003_ta/html/odc_accessnewxmlfeatures.asp

 

[Brendan Reynolds]

BTW: My apologies for overlooking the reference to Access 2000 in the
subject line.