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