Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting to Excel
Message
From
17/07/2003 18:48:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
17/07/2003 18:32:46
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00811313
Message ID:
00811318
Views:
12
>Hi Everyone
>
>Is there a way to perform a COPY TO or anything else in order to export to Excel more than the 16383 records in only single command?
>
>Thanks in advance for any hints
>
>Oscar

1) Use Automation, one cell at a time. This uses many commands, and it is slow.

2) COPY... TYPE FOXPLUS, and use Automation to import it into Excel.

3) Upgrade to VFP8 - I understand it supports the full 65,000 rows for Excel.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform