I still not sure why do you want to retrieve recordset instead of getting XML directly from SQL Server using 'FOR XML' clause. Anyway, you can conver returned cursor into XML using XMLTOCURSOR() function.
>Sorry if I did not make myself clear. All I want is to save the records returned by the select statement into a XML file in the client computer. Let's say I have the following statement:
>
>
> Select * From Employees
>
>
>Then I want all the records from the Employees table to be saved into a XML file named C:\myXMLFiles\Employees.xml, for example.
>
--sb--