I want to read an xml file in asp page then create a string variable inorder to store a chunk from that xml file inorder that i can send it to sql server as a varchar data via stored procedure. any help?

i have the first part which is read the xml file into asp page:
SET objXMLDoc_bannerClicks = Server.CreateObject("Microsoft.XMLDOM")
objXMLDoc_bannerClicks.async = False
blnFileExist = objXMLDoc_bannerClicks.Load("bannerClicks.xml")



ak

__________________
ak

You can access the XML from the document (through the DOMDocument object) via the XML property (I think, it's been a while, but there is a property). You should be able to access XML at the node level also. I think you want to look for the XML and InnerXML properties. Look in the MSXML Parser SDK.