Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy To Type XL5 - limit on number of records?
Message
 
 
To
05/02/2009 16:09:57
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01379610
Message ID:
01379646
Views:
40
Right, try the approach recommended in the message Sergey pointed you to instead.

>In VFP9, using:
>
>COPY TO (lcReportFile) FIELDS &lcFieldList TYPE XLS
>
>still only copies 65000 records. It appears that the VFP copy to command is limited as well using xl5 (expected) and xls types...
>
>The help for COPY TO states a max of 65,535 rows and versions of excel prior to Excel 97 will only read 32,767 rows...
>
>(Can't believe I missed that when I read the help earlier)
>
>>The 65,000 is a limit of VFP9 COPY TO xls command and Excel itself before Excel 2007.
>>You can try Export To Excel Causes COM Error Message #1292509 instead
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform