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