| || |
Save Recordset as XML file
I need to save the ADO recordset returned by executing a query on db as XML file .
Here is a simple piece of code (with which I am trying to achieve the same) :
'Open connection and then execute the query
Set Rec = DB_object.execute(db_query)
Rec.Save "c:\qtp\Example.xml" , adPersistXML
This is resulting in corrupt file .
Can someone help in this regard ?
Re: Save Recordset as XML file
Did you define adPersistXML?
Msgbox adPersistXML 'what do you get for this?