I quit using Copy to.....Xls a while back and use Automation to create a spreadsheet and populate it. This method also allows for flexibility as you can format the spreadsheet while you are doing the copy as well as doing things like creating columns that are formula based.
PF
>It seems that the documentation for VFP6 states that you can use the command:
>
>COPY TO FILE TYPE XL8
>
>This does not seem to work, can comeone offer some suggestions.
>
>We are attempting to copy rather large subset of a table to excel and are faced with the 16k line limit which cuses much grief. We need to be able to export to xls up to 50k records.
>
>Thanks for your help.
(On an infant's shirt): Already smarter than Bush