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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML and MS Access 2000

Status
Not open for further replies.

SERICAN

Technical User
Aug 2, 2005
1
US
I'm new, so pelase ignore my ignorance

1) Can you import XML files into MS Access 2000?

2) if so how? Do i need to download something?

Thanks i nadvance
 
I don't think A2000 knows anything about xml. The first version with built-in xml features was a2002, I believe.
 
Not certain about 2000 and importing xml but can always use Microsoft.XMLDOM

small sample just pass the path
xmlparse("c:\myfiles\myxmldoc.xml")
Code:
Public Function XMLparse(stpath As String) As Boolean
 Dim xmldoc As Object, x
 Set xmldoc = CreateObject("")
xmldoc.async = "false"
xmldoc.Load (stpath)
For Each x In xmldoc.documentElement.childNodes
  Debug.Print x.nodename
  Debug.Print ": "
  Debug.Print x.Text
Next
  Set xmldoc = Nothing
 End Function
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top