XML and Access 2000

[gruffallo]

I don't know if anyone out there has any tips for
importing XML files into Access 2000. I have found an
article on the web that explains how one person has done
it which is very useful but I have about 20 different XML
files to map to Access tables and this method would
require a recode for every template!

Has anyone done anything or know of any code available to
do these imports without upgrading to Access 2002??

 

[solex]

I'm not sure if there is anyway around your problem of needing to code. But
if you are simply importing a flat xml file to a table, you could get a
simple XML style sheet to convert the data to a CSV and then import directly
into access.

Dan

 

[John Nurick]

If you upgrade at all, go for Access 2003, which has significantly
better XML support than Access 2002.