Why not pass the ADO recordset to a VFP Component, Convert the Recordset to a VFP cursor, and then save the cursor to whatever format you need with the COPY TO VFP command?

>Thanks Tim
>Most of our clients ask for data to be transferred as an sdf file, or as a comma delimited file. I need to send them the data in a format they can easily import into whatever data management program they may be using. I know that XML is the way things seem to be headed, but for now I need a format they can understand.
>
>Bill
>
>>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