Mike,
Not fixed and I think will never be (Never say Never < bg >)
Unless Excel automation is used fox side simple commands have disadvantages. CSV and Fox2x break the rowcount limit but still has spreadsheet rows limit. Fox2x truncates long fieldnames (BTW doesn't lack codepage conversion).
Both CSV and fox2x fail on transferring memo fields succesfully.
If you don't have memo fields and rowcount is under current limit (65535 - 1 header line) simpliest is CSV IMHO. In VFP5 you could use Fox2x or delimited file.
In FoxyClasses DBF2Excel solves the problem by extending rows to multiple sheets + uses ADO when necessary.
Cetin
>Thanks Cetin,
>
>I knew it couldn't be my problem. This is one of the very few times that I can blame it on VFP <bg>.
>
>Does MS know about this and is it fixed in 7.0?
>
>
>>>Does anyone know if there is a limit to the number of records that can be "COPIED TO TYPE XL5"?
>>>
>>>I have a VFP6.0 table with over 26,000 records that I want to create an Excel spreadsheet for. When I use:
>>>
>>>COPY TO myfile TYPE XL5
>>>
>>>the resulting spreadsheet only contains 16384 rows! I've tried "COPY myfield TO myfile TYPE XL5" but still only got 16384 rows. What am I doing wrong?
>>>
>>>TIA.
>>
>>Yes it's the known limitation when type XL* used. Instead copy type CSV or fox2x.
>>Cetin