Nadya,

It's an even greater FAQ answer :)

As for it being fixed in VFP7...I don't know, however, until I find out for sure, I'm not tossing Daniel's butt saving code! I'm hoping that it also works in VFP 7.0.

>Mike,
>
>I'm using it too. Great FAQ!
>
>BTW, does VFP 7.0 fix this problem?
>
>>Nadya,
>>
>>Thanks for the lead. I downloaded Daniel's code and it works great!
>>
>>>>Does anyone know if there is a limit to the number of records that can be "COPIED TO TYPE XL5"?
>>>>
>>>>I have a VFP6.0 table with over 26,000 records that I want to create an Excel spreadsheet for. When I use:
>>>>
>>>>COPY TO myfile TYPE XL5
>>>>
>>>>the resulting spreadsheet only contains 16384 rows! I've tried "COPY myfield TO myfile TYPE XL5" but still only got 16384 rows. What am I doing wrong?
>>>>
>>>>TIA.
>>>
>>>See FAQ #8026 by Daniel Gramunt "How to copy more than 16,383 records to Excel"