Mike Sue-Ping
Cambridge, Ontario, Canada
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"
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only