Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import XML into Access 2000

Status
Not open for further replies.

willpwr00

Programmer
Oct 29, 2003
2
US
I've seen many similar questions here without any answers. Does anyone know how to import XML files into Access 2000? OR how about reading XML files via VBA? A solution will help numerous other folks searching this site. You will be a god!
 
I've seen many similar questions here without any answers.

That's probably because there isn't an answer, at least not one you want to hear.

Access 2000 doesn't provide a one-step import of XML documents. If you want to do this, you're stuck writing your own program (in VBA, VB, Delphi,...) to parse the XML document and populate a database.

HTH,
harebrain
 
I was afraid that was going to be the answer. Guess it would be best to spend the $99 and get the 2002 upgrade. Thanks for replying.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top