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
Beyond Excel's maximum row limit (Read 6351 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Beyond Excel's maximum row limit
23.08.07 at 16:13:42
 
Beyond Excel's maximum row limit
 
SQL*XL has been improved to not be limited to the number of rows in the Excel sheet when retrieving data from a database. Hitherto SQL*XL would display a message when it reached the end of a sheet indicating that the maximum number of rows were fetched. Now SQL*XL is programmed to continue on a new worksheet (tab). It adds a new tab to the workbook and it will continue at cell A1 on that sheet. If that sheet is full another sheet is created, etc.
 
There is always a limit.
What is the next limit of the number of rows that can be fetched by SQL*XL. Nothing is endless and there is a new limit. It is not defined by Excel but by your computer's available memory. As the data is put in Excel it is actually put in memory first by Excel. Since memory is finite it will be used up at some point. As long as there is memory available the fetching of data can continue.
 
Note that if you plan to fetch an enormous number of rows that you should use the large resultset option to reduce memory usage.
 
This new feature is implemented in SQL*XL 4.2.4
Back to top
 
 

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