Reading in XML with Access 2000

G

Gary Watson

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
 
B

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?
 
G

Gary Watson

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


Brendan Reynolds said:
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?
Click to expand...
 
B

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
 
B

Brendan Reynolds

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