>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