David,

AFAIK, VFP cursor cannot be converted into new ADO recordset with CA. Alternatives:

VFPCOM.DLL

West Wind XML Converter http://www.west-wind.com/wwxml.asp

mskb #192762 Dbf2rs.exe Converts a VFP Cursor to ADO 2.x Recordset

>I'm not able to find this answer anywhere. I've done a lot of code that takes an ADO recordset and converts it to a VFP cursor, but now I've got to find an easy way to go the other direction. Given a VFP cursor convert it directly to a recordset.
>
>This code goes from RS to Cursor:
>
<snip>>
>Ideally I need the RS to construct its field collection structure directly from the cursor structure and then push the data into the RS. The CursorAttach() method returns .t. but oRS is pretty much an empty shell. What am I doing wrong/missing? I don't really want the run a select, it doesn't have to be updateable, it's just a RS that we are passing from a VFP COM object over to an ASP page.

--sb--