>Is there anyway to use APPEND FROM using a view instead of another table? Or should I just use something like a loop and INSERT INTO?
I tend to do it this way (assuming the table and view are the same structure).
SELECT * FROM myView INTO ARRAY laMyArray
IF _TALLY > 0
INSERT INTO MyTable FROM ARRAY laMyArray
ENDIF
HTH