Can you covert ADO recordset to a cursor and than use CA to MS Access to move records there?
>Sergey, thanks for the reply. Looks like your link shows how to connect to MS Access.
>
>What I need is a way to take an existing ADO recordset and in essence copy that recordset to MS Access. When I need to copy the ADO data to a VFP table I just use a CURSORADPTER but not sure how to copy the ADO data to MS Access...
>
>>See
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet
--sb--