>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?
You can use APPEND having some adjustment:
select view1
cTablename=dbf()
select table1
append from &cTablename.
Edward Pikman
Independent Consultant