>Hi Nigel ---
>
>Nice new picture. Tell Evan to give you your beard back!
>
>Anyway, Excel will allow 65536 rows. The 16384 row restriction has soemthing to do with the COPY TO ... TYPE XLS command. A solution might be to COPY TO TYPE DELI and import it into Excel.
>
>>>I use 'copy to aa.xls type lxs' to transfer my dbf record to a Excel format file ( about 30,000 records )....
>>>But i found that only 16,384 records had transfered.
>>>Why ?? ( and how to fix it )
>>
>>
>>Excel will only allow 16,384 rows. Add to this however many columns you can have and you've got a large spreadsheet!
John,
Apparently the 16384 row limitation goes back into the dusty past of FoxPro (maybe even FoxBase) and for some odd reason the developers have never "upped" it. I've run into this myself and your suggestion to send the information out to a TEXT file works without a hitch. You can also export to a DBF but that can be problamatic depending on the column header names you've used.
Best,
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.
