>>Is it possible to create a cursor from a SQL SELECT and then APPEND FROM to an existing table?
>
>Sure
>
>SELECT * FROM table INTO CURSOR mycursor NOFILTER
>SELECT anothertable
>APPEND FROM (DBF("mycursor"))
>
>You could also SELECT ... INTO ARRAY then APPEND FROM ARRAY instead - depending on the size of the returned data set.

I changed to an array and it gets done what I need, thanks!