Copy to does not appear to append records, append from might work, but can a add additional fields and if so how?
>You could say...
>
>
SELECT Order_List
>COPY TO temp TYPE DBF
>
>You could specify where "temp" is to be saved, for example, "c:\temp", if not, the above will save it to the current directory.
>
>If you lookup COPY TO in the Visual FoxPro index, you can see what other types of files that you can copy the contects of the selected table to, I just used DBF here as an example.