Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO ~.xls TYPE XL5
Message
From
12/07/2000 00:00:20
 
 
To
11/07/2000 22:46:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00391066
Message ID:
00391083
Views:
12
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform