Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel 2003 - 16384 row limit (Read 9747 times)
spaul123
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Excel 2003 - 16384 row limit
18.07.07 at 15:31:28
 
Hi,
  I am using Excel 2003 with Oracle 9i database. When I try to import data(with more 16384 rows) from Oracle into excel spreadsheet using SQL*XL, I receive the following error:
 
Excel allows only 16384 rows per sheet.
 
All, I am able to import is 16384 rows. But I did not have this problem in Excel 2000 which I was using earlier. It seems to be the problem with Excel 2003. Does anyone have any suggestions to fix this on Excel 2003? Is there any work around for this to be able to import more rows than 16384. Please advise.
Back to top
 
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Excel 2003 - 16384 row limit
Reply #1 - 29.07.07 at 11:23:25
 
Do you use a very old version of SQL*XL? This problem was fixed and the current version (4.2) allows full usage of the spreadsheet (about 65,000 rows for Excel 2000, 2003 and about 1 million rows for Excel 2007).
 
If you have a very old version of SQL*XL shall we look at upgrading it to the latest version? You may benefit from other updates and fixes.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Excel 2003 - 16384 row limit
Reply #2 - 24.08.07 at 07:52:23
 
Please note that the row limit is now lifted. When SQL*XL reaches the end of the worksheet it will add a new sheet and continue there. You can query as many rows now as you like.
 
See:
Beyond Excel's maximum row limit  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1187878422/0#0
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1