Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using ADO to populate Excel has 16k row limit
Message
 
To
04/08/2008 15:46:20
Jim Newsom
Icg, Inc.
Dallas, Texas, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Using ADO to populate Excel has 16k row limit
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01336326
Message ID:
01336340
Views:
14
I believe, it is not ADO limitation, but Excel's. And it depends on Excel version.
What are expected records number you want to copy?

Other than that, I am curious of why do you use ADO to connect to VFP table, and then copy records from ADO recordset to Excel; and what is the reason to do it one by one?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform