importing xml file

[curt]

We are using Access 2000. Is there a way to import or
link to an xml file? None of the filters we have seem to
support xml files. Access 2002 does, but we don't want to
migrate yet. Any ideas?

 

[Joe Fallon]

A97 & A2000 were tough to use with XML.
I wrote my own import routine.
It was a nightmare. (But works.)

I recommend A2003 if you want to use XML heavily.
A2002 is OK, but 2003 really makes it straightforward.

 

[Rick Brandt]

We are using Access 2000. Is there a way to import or
link to an xml file? None of the filters we have seem to
support xml files. Access 2002 does, but we don't want to
migrate yet. Any ideas?

You can use the MSXML.DLL library to create a DOM Document based on the XML file
and then use its methods to loop through and write the data to a table. It's
not trivial however.