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 Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05