I have to export the recordset data to XML file in my vb 6.0 application.

XML file should be in predefined XML format and XDR file is also given along with that.I am using MSXML to do this.

I was wondering if anyone can suggest a better way to do this.

If it's coming from SQL, you could investigate the use of "FOR XML AUTO" in the query. I am by no means any expert with this, but have used it a little in the past and know that it can produce basic forms of XML.

Regards,

Sean Anderson

hi

If You Are Using ADO Recordset Object then the job is simpler

'fill the records from the database table into a ADO Recordset for example rsEmployees

'write the following piece of code to get the xml document from the recordset object along with a Schema

rsEmployees.Save "C:\Data.xml",adPersistXML

thats all u will have the xml format of the recordset data stored in the file C:\Data.xml

hope this wud help u solve the above problem..



Regards,
Raghu