xml help

[roh_8_it_3]

hi all,

i m trying to insert the data from the xml file to the sql server using msxml2 and ado.but i m stuck here-

i have loaded the xml document and also called the recordset using ado.now i m trying to insert data in this recordset like this-


For Each objxmlbooknode In objxmlnodes
With objxmlrec
.AddNew
.Fields("BookTitle").Value = objxmlbooknode.selectNodes("Titles")
.Fields("Publisher").Value = objxmlbooknode.selectNodes("Publisher").Item(1)
.Fields("DateOfPurchase").Value = objxmlbooknode.selectNodes("DateOfPurchase").Item(2)
.Update
End With

Next objxmlbooknode

but after selectnodes. it dont gives me a value option.so how can i get the value of the nodes.

thanks