>>>>>
>>>>>>>Only copies 16,384 records. Is this a VFP limit or can it be overriden
>>>>>>>
>>>>>>
>>>>>>This is Excel limit.
>>>>>
>>>>>Are you sure? I can add rows to the Excel sheet beyond 16384 in the test XL file.
>>>>
>>>>It depends on Excel version.
>>>>Excel 7.0 Help: "Maximum sheet size 16,384 rows by 256 columns"
>>>
>>>OK, that may be. I'm running Excel97 SR1. Still, though, that maximum is imposed by VFP in the copy so the workaround has to be in VFP.
>>
>>Try EXPORT command.
>
>Nope....same problem.
I remember similar thread few months ago, and I cannot neither find it nor remind what was the solution. Probably, it was some OLE automation. Sorry :)
Edward Pikman
Independent Consultant