XML and Access 2000

  • Thread starter Thread starter gruffallo
  • Start date Start date
G

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??
 
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
 
If you upgrade at all, go for Access 2003, which has significantly
better XML support than Access 2002.
 
Back
Top