Try this instead:
SELECT table1
DELETE TAG ALL
APPEND FROM table2
INDEX ON colname1 TAG colname1
INDEX ON colname2 TAG colname2
etc..
>I am testing an old program converted to VFP 7.0 that basically does the following:
>
>SELECT table1
>REINDEX
>APPEND FROM table2
>
>Records appended are in the hundreds and I always end up with corrupt tags which are unable to locate records.
>
>I remember reading something about appending large number of records that might throw the tags out of whack. I would recommend issusing 'reindex' after the 'append' command.
>
>Would appreciate greatly your feedback.