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