Don't forget the quotes around the cursor name your appending from. But right on track.

select * from table1 where wherecond into cursor curtemp

select table2
append from dbf('curtemp')