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
limits or exceptions dumping tables (Read 1733 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
limits or exceptions dumping tables
17.12.09 at 16:30:42
 
limits or exceptions dumping tables
 
Quote:
Are there any limits or exceptions when dumping tables or a whole schema of tables into Excel?

 
Not really.
An Excel worksheet has a limited size. Approx 64k rows or 1M rows depending on whether you run Excel 2007 or not. If the end of the sheet is reached it continues on a new sheet it inserts. There is no limit to the number of sheets you can have in Excel.
 
There are always limits:
If the spreadsheet does not fit into memory anymore, that will be a problem. For a very very large table SQL*XL can consume a lot of memory. Use the large tabel option to prevent this. When you just download data to Excel this is not a problem.
There can be a datatype SQL*XL does not know how to handle. I don't know whether you developed custom column types.  
Back to top
 
 

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