>>>>>>
>>>>>>>>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 :)


Try this:

COPY TO [path\filename].xls

Don't use the xls clause at all. It makes a dbf, but with the xls extension. Excell will open it without any dialog hassels, because it has the proper extension (you've fooled Excell!), and you can then save it and just answer yes when it asks about using current version formatting. My boss and I discovered this recently.

Dana