Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Dialogs Resultset Options

Buy now

Download now

SQL*XL online help

SQL*XL: Resultset Options dialog: XLS

Target: Pivot table (Resultset options dialog)


When pivot table is selected as target for the fetched results the data will be attached to a pivot table in Excel. SQL*XL will create a new pivot table and attach the resultset. When a pivot table already exists (query refresh) SQL*XL will keep the pivot table with all the settings you may have set and just replaces the query results.

The following options can be set:

See also:

SQL*XL ribbon in Excel