How can i load data from an xml file into a database table , through ADO , the
thing is that you open a recordset persistently.But i am not getting the results . here is my code ;

con.Open constr

rs.Open "c:\test.xml", "provider=MSPersist", adOpenDynamic, adLockBatchOptimistic, adCmdText