>>Hi,
>>When I use the COPY TO ... TYPE XLS, it seems that only the first 7000+ records of the table copy. I know there was a limit in Fox 2.6. Is there a record limit in VFP 6.0?
>>Thanks,
>>John
>
>John,
>We have had multiple discussions recently about this. When doing the COPY TO command for excel, you only will a little more than 16,000 records, but Excel has a bit more than 65,000 limit in it. When Excel upped its limit, Foxpro did not.
>
>HTH

You can use COPY TO MySpreadsheet TYPE XL5 in VFP6.