I should have added, the reason to use COPY TO instead of COPY FILE is that you get the entire range of qualifiers in COPY TO such as scope, filters, conditionals, etc.

>For the command:
>
>COPY FILE P:\tables\item.dbf to Litem.dbf
>
>If the Litem table already has data, will the COPY FILE automatically delete the existing records before copying the item.dbf to the Litem.dbf?