Mike and Nadya,

Thanks for the kind words.

Well the behaviour hasn't changed in VFP7. The same limitation still applies and the workaround described in the FAQ still works. What's interesting is that the workaround is actually faster than the native COPY TO TYPE XL5 command! At least on my Dell Dimension. I get slightly different results on my notebook.

The good performance is due to the fact that COPY TO TYPE SDF which is used in Copy2Xls() is extremely fast. Much faster than XL5 and even faster than COPY TO TYPE FOX2X.


>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"