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