>Has anyone seen a workaround for this? I have 38k rows to spit out into a .xls and VFP is hurting me. Worse, the MSKB article only references VFP3...
>
>
You could try using the _VFP.DataToClip() function and then using automation to paste into Excel. You might need to do your data file in segments, there is some kind of limit to the total size you can put into the clipboard.
>
>>>I've just discovered (the hard way) that COPY TO TYPE XL5 seems to be limited to 16383 records. BTW, EXPORT TO has the same limitation. I can't find any documentation confirming this behavior. The tricky thing is that VFP doesn't return any error. It simply stops copying after 16383 records...
>>>
>>>I guess the only solution is to use automation to pull the records into Excel. This of course is much slower than COPY TO :(
>>>
>>>Can anyone confirm or preferably deny this limitation :)
>>
>>>>It's a fact.
>>See MSKB#
Q103355<<
>>
>>Trey,
>>
>>Thanks for the confirmation. I've written a wrapper that uses automation if the number of records exceed the limitation.
>>
>>Daniel