The article ADO Jumpstart for Microsoft Visual FoxPro Developers by John Petersen should help you http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp. You can also use CursorAdapter Re: Cursoradapter Object Message #781487.

>
>I created a command object using cMmd = CREATEOBJECT('ADODB.COMMAND')
>funtion, and retrive data from mytable using cMmd .CommandText = 'Select * from Mytabel' method, is working fine, but how can i see the query result ?
>i just add one line after like
>Select Mytable
>brow
>gives the error that 'Alias Mytable is Not Found'
>i need this result is in a table form, because after that i want to
>index and seek the values in this table.
>OR if i m using Recordset commands can i see the results?
>but i do'nt know how to use these commnds, please help me
>anybody knows abt it
>