>>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

Sorry for interrupting. There is one problem with this approach. When you SELECT from View, VFP tends to go to actual tables, i.e. if user changed view records but didn't issue Tableupdate() yet, then newly selected_from_view recordset will not contain the last changes.