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 15:08:30
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:
01379632
Views:
54
This message has been marked as the solution to the initial question of the thread.
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

>
>COPY TO (lcReportFile) FIELDS &lcFieldList TYPE XL5
>lnRecordsCopied = _TALLY
>
>Is there a limit to the number of records that can be copied over? I'm seeing a difference between the source table and the result xl5...
>
>Is _TALLY not valid ?
>
>After copying 130,000 records, _TALLY shows 65,000...
>
>I don't see any other table activity in-between to change the _TALLY .
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform