From the Hacker's Guide (vfp7):
Earlier versions of Excel permitted a maximum of 16,384 rows. Although more recent versions of Excel extend that limit to 65,536 rows, neither COPY TO nor EXPORT will create an Excel file with more than 16,384 rows. This is because COPY TO only supports XL5 copying, while APPEND FROM and IMPORT support XL8. This is sort of a "by-design" gotcha, but we sure wish they'd change it.
>Hi
>
>I import an HTML file into Excel. Fine - no truncation.
>
>However, the XLS needs to be processed by an old FPD2.6 system, so I save as an XLS 3, so the old system recognises it.
>The data are then processed into a DBF.
>
>It's just been noticed that a fair slice of the data have been lopped off, to 16384 rows.
>
>I suspect thet Excel 3 has a max file size limitation, of c. 16K rows or something like that. Is this the case? I haven't a copy thereof to check.
>
>Secondly, any ideas on how to get round this? (I saved to Excel 3 as a precaution, as FPD2.6 won't recognise 97 as I have on board) How recent can I go with Excel versions?
>
>'ppreciate it.
>
>Terry
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
