No, none of the records in the Fox table are deleted.

The funny thing is that it is NOT the same number of records every time.

It will add 990 one time, then 993 another time. It is not the same.

Is append from a bad command to use with SQL??? It would certainly be a LOT easier if it did work.

THANKS