>Hi.
>
>I would like to copy data from a VFP table to a file of Excel 5.0.
>So I used COPY TO command.
>
>Select customer
>COPY TO c:\cutomer.xls TYPE XL5
>
>The customer table has 60,000 records. COPY TO command ran without any errors. But when I opend customer.xls at Excel 7.0, there were 16,384 rows.
>
>Is that a bug?
>help me.
>
>Thanks.
Excel has a limit on how many rows it supports in a worksheet. It looks like 16K is it for XL5. I think later versions might support more rows (maybe 32K or more?)
Your best bet is probably to copy out portions of the customer table to separate worksheets. Maybe A-F, G-L, M-R, S-Z by surname.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up