>Hi Michael,
>
>>It seems both commands:
>>
>>copy to (sheet) type XLS
>>copy to (sheet) type XL5
>>
>>are both limited to 16,000+ records. I thought there was an "xl8" clause but that doesn't seem to be. Any ideas on how I can get all the records copied? I can use a "csv" file if necessary, but I'd like to have the field headers copied also.
>
>Ed Rauh answered this in DBF to Excel format Thread #401778 Message #401778 posted on 08/07//00.
>
>According to the Almighty Ed Rauh: <g>
>It's a limit placed on VFP by compatibility requirements for some earlier versions of Excel; the solution is to use Ecel's ability to read a table, or create output in another format that Excel can handle like a CSV file, or use Excel automation.
>
>HTH
>
>Jon

I think the limitation might be 65,000 cells so the number of rows you can import is dependent on the number of columns you have. I wrote a small class that exports to excel and during testing this issue came up.

The class does not use the COPY TO command but instantiates an Excel app and uses it to do the import.

Steve