Dim xmlDoc Dim currNode Set xmlDoc = CreateObject("microsoft.xmldom") xmlDoc.async = false xmlDoc.load("c:\books.xml") Set currNode = xmlDoc.documentElement.childNodes.item(1) MsgBox currNode.xmlyou can read a xml into a SP also,though i find it quite restrictive, have a look at OPENXML function in SQL 2000