Hi all,<BR><BR>Have managed to build half an insert statement which pulls values from an XML doc - it seems to be outputting the correct result but at the end is an error.<BR><BR>The error goes like:<BR><BR>Microsoft VBScript runtime error &#039;800a01a8&#039; <BR><BR>Object required: &#039;item(...)&#039; <BR><BR>/test/xml/komedy2.asp, line 14 <BR><BR><BR>The code being used is:<BR><BR>Set xmlDoc=Server.CreateObject("Microsoft.XMLDOM")<BR> xmlDoc.async="false"<BR>xmlDoc.load(Server.MapPath ("/test/xml/com_sam.xml"))<BR><BR>TotalVenues = xmlDoc.selectNodes("listing/venueList/venue").length<BR><BR>strSQL = "INSERT INTO tblVenues "<BR><BR>For i = 0 to TotalVenues<BR><BR> Set objChildNodes = xmlDoc.documentElement.childNodes.item(0).childNod es.item(i).childNodes<BR><BR> For Each strNode In objChildNodes<BR> If strNode.text &#060;&#062; "" Then<BR> strSQL = strSQL + strNode.text & ", "<BR> Else<BR> strSQL = strSQL + "Null" & ", "<BR> End If<BR> Next<BR>response.write(strSQL)<BR>Response.Write(" &#060;HR&#062;")<BR>strSQL = ""<BR>Next<BR><BR><BR>Be gratefull if someone can spot any mistakes.<BR><BR>regards,<BR><BR><BR>KS