importing xml file

  • Thread starter Thread starter curt
  • Start date Start date
C

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?
 
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.
 
curt said:
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?
Click to expand...

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.
 
Back
Top