Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using ADO to populate Excel has 16k row limit
Message
 
 
To
06/08/2008 16:19:07
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01336326
Message ID:
01337043
Views:
11
>Hi Yuri,
>
>I found the problem. Thanks for your input. Another change unrelated to ADO caused the issue. The wrapper class invoked workbook.SaveAs() using an earlier version of Excel as the file type, for backward compatibility. (Excel 95)
>
>The ADO call properly put all the rows into the sheet from the cursor, but after SaveAs() saves the file in that earlier version, it imposes the excel 95 sheet size limit at that time. I had to fix that part to resolve the problem.
>
>Thanks again, I apologize for the delay in responding.
>

Great you found the problem.
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