>>>I am using the following code to retrieve data into VFP from SQL Server 7.0:
>>>= SQLEXEC(gnConnHandle, lcQuery, "query1")
>>>---------------------------------------------------------
>>>The result is a CURSOR called query1. My ultimate goal is to export the data to a text file.
>>
>>
>>With the cursor created by the SQLEXEC function, you can use the EXPORT command. You don't need to pass through ADO for this.
>
>That is correct. I just wanted to use OLEDB instead of ODBC.
You can use the VFPCOM utility to transform a recordset to a cursor and vice versa. But the added overhead to do this would far outweigh any benefits you got from using the OLE-DB provider. IMO, stick with what you've got.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao