As of ADO 2.1, the save method saves the recordset to disk as an ADO Recordset, or an XML file.

>Thanks Tim
>
>I had looked at the save method, but the documentation seemed to indicate that there were no options available for what format the generated file would be in. Can you shed any light on this?
>
>Bill
>
>
>>You can use the save method of the recordset to save the recordset to disk.
>>
>>>Hi
>>>I am using ADO to display VFP data on a web site. I need to give our clients the option to download the recordset they are reviewing. Is it possible using ADO to export a recordset to an SDF or comma delimited file? I haven't seen any ADO documentation on exporting a recordset or saving it to file. Is it necessary to create a file and write the recordset to the file 1 field at a time?
>>>I could create an automation server to accomplish this with internal VFP commands, but I would like to avoid the overhead involved.
>>>
>>>TIA
>>>Bill Sabo