Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting to Excel-size limit
- Thread starter AMakovoz
- Start date
I guess the easy answer is that 16,384 rows is the maximum, except I can't find that documented.
My Excel 2000 documentation says that a single worksheet is limited to 65,536 rows by 256 columns, and your 16,384 is exactly 1/4 of this. Earlier versions of Excel may have had smaller limits.
If you are using EXPORT ... TYPE XLS, try using EXPORT ... TYPE XL5. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
My Excel 2000 documentation says that a single worksheet is limited to 65,536 rows by 256 columns, and your 16,384 is exactly 1/4 of this. Earlier versions of Excel may have had smaller limits.
If you are using EXPORT ... TYPE XLS, try using EXPORT ... TYPE XL5. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
The explanation that I always receive when inquiring about this is as follows:
"It's a limitation that was carried over from the FoxPro for DOS days."
As Robert eluded to, my assumption for the limitation was that in the early days of Excel, the per sheet limit was 16K. And thus this limitation was carried forth with FoxPro into VFP.
One solution is to automate Excel and import the data to the spreadsheet. But, keep in mind, if your data exceeds Excel's 64K rows per sheet limit, you'll have to divide you data among multiple sheets. [sig]<p>Jon Hawkins<br><a href=mailto: jonscott8@yahoo.com> jonscott8@yahoo.com</a><br><a href= > </a><br>Carpe Diem! - Seize the Day![/sig]
"It's a limitation that was carried over from the FoxPro for DOS days."
As Robert eluded to, my assumption for the limitation was that in the early days of Excel, the per sheet limit was 16K. And thus this limitation was carried forth with FoxPro into VFP.
One solution is to automate Excel and import the data to the spreadsheet. But, keep in mind, if your data exceeds Excel's 64K rows per sheet limit, you'll have to divide you data among multiple sheets. [sig]<p>Jon Hawkins<br><a href=mailto: jonscott8@yahoo.com> jonscott8@yahoo.com</a><br><a href= > </a><br>Carpe Diem! - Seize the Day![/sig]
- Thread starter
- #4
Thank you, Jon & Robert,
I am using Excel 97 with 64K size limit. The solution I found was to split Export to several sheets with max of 15,000 rows each and then merge them back to one using automation. Initially I programmed it with OLE, but it would take forever to download around 40,000 records.
Thanks again. Albert [sig][/sig]
I am using Excel 97 with 64K size limit. The solution I found was to split Export to several sheets with max of 15,000 rows each and then merge them back to one using automation. Initially I programmed it with OLE, but it would take forever to download around 40,000 records.
Thanks again. Albert [sig][/sig]
AMakovoz,
I have run into this several times also. It is a FoxPro Export Limitation Problem. Here is what I do to get around it.
I export the info to a delimited file.
Start Excel and import the file.
I can pass up to 64,000 records this way. [sig]<p>David W. Grewe<br><a href=mailto
ave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br> [/sig]
I have run into this several times also. It is a FoxPro Export Limitation Problem. Here is what I do to get around it.
I export the info to a delimited file.
Start Excel and import the file.
I can pass up to 64,000 records this way. [sig]<p>David W. Grewe<br><a href=mailto
ave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br> [/sig]- Status
Similar threads
