Try

* vfp 7.0
Select * from table INTO CURSOR curTable READWRITE

SELECT curTable
APPEND FROM table2


* VFP 6.0
Select * from table INTO CURSOR curTemp

lcDBF = DBF()
SELECT 0
USE &lcDBF AGAIN ALIAS curTable
USE IN curTemp

SELECT curTable
APPEND FROM table2


Unions with MEMO fields don't work so well.