There is a function in the VfpCom dll that will convert an ADO Recordset to a VFP cursor.

Once you get the file in the format you want, how are you getting the file to the client's system?

>Hi Tim
>Funny you should ask. I was creating a VFP com server to export the recordset. I was passing the query parameters to the VFP server and having it create a cursor and export it to a file. It just seemed like a lot of overhead, creating a recordset in VFP that I already had in ADO - thought there might be a better way. If you don't mind me asking - is it a simple process to convert an ADO recordset object, passed to a VFP component, into a VFP cursor? Currently I am passing the query parameters used by the ASP page to the VFP server to create the cursor.
>
>Thanks
>Bill
>
>>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