Linker IT Software
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
Using pivot tables with SQL*XL (Read 2817 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Using pivot tables with SQL*XL
10.11.10 at 11:20:12
Using pivot tables with SQL*XL
I am able to build a SQL statement, run it and have the data displayed in Excel. I can then build a pivot from that data. However, that approach won't work with large tables in which the number of records exceeds that of Excel. Is there a way to build a pivot table in Excel utilizing the tables in Oracle? One way we currently handle large tables is to export them from Oracle; import them into MS Access; then build the pivot using external data. Our company is hoping your product will help us eliminate these steps.

There is a very elegant solution for this. SQL*XL uses so called output targets. The default is Excel and using it data flows directly into spreadsheet cells. This is how most people use the software.
However another output target is pivot table. SQL*XL will create a new pivot table and attach the results from the query to it. There is no maximum limit on the number of rows! There are a few nice features of this:
- The user can disconnect and open the spreadsheet at a later time or on a PC even without SQL*XL and still have the pivot table fully functional.
- The user can reconnect to the database and refresh the resultset behind pivot table
Back to top

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