Jim,
>select ... into cursor mycursor
>select mytable
>append from dbf(mycursor)
Be warned if you are doing this on the order of thousands of times the append from can randomly fail with alias not found errors. I've had to switch to using
into table instead.