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
SQL output target (Read 6156 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
SQL output target
03.06.07 at 22:29:03
SQL output target
When you run a SQL select statement SQL*XL will give you a set of options where to put the resulting data. Most times you will want to put the results into Excel so the default option is target Excel. However you may want to chose a different output target. The possible output targets and their use is listed below:
  • Excel:
    This is the default output target. SQL*XL will put the results for the SQL select statement into the current instance of Excel.
  • Pivot table:
    SQL*XL can attach the output of a SQL select statement to a pivot table. When you select an existing pivot table SQL*XL can add the results to that pivot table. When you do not select an existing pivot table SQL*XL will create a new pivot table for you.
  • XLS:
    SQL*XL will create a new binary XLS file when choosing the XLS output target. This very fast option to dump data into Excel will not put any formatting to the data. It will write a new binary XLS file. This is the fastest way to transfer data into Excel.
  • Word:
    Occasionally it is handy to receive the data into MS Word. SQL*XL will open MS Word and put the query results there. Note that this is only useful for small results sets.
  • Outlook:
    To share the results of a SQL select query with someone you may want to put the results directly into an email. When you choose the output target Outlook SQL*XL will create a new email containing the query results.
  • XML:
    SQL select statement results can be stored as ADO XML files. The only requirement is that you have not connected through OO4O to Oracle. All other database connections are supported including all other Oracle connections through e.g. ODBC or OLE DB.
  • Text/CSV:
    To just create a file with the data the text/CSV output target can be used.
  • PDF:
    SQL select statement results can be stored as PDF files using this option.
  • No output:
    This may be a curious one. You can select that SQL*XL makes no output at all. This may be desirable if you have used the MergeFields function to show the data in a template spreadsheet. Use the control panel in the toolbar to show the data.

Further reading:
Back to top
« Last Edit: 04.06.07 at 07:38:13 by Gerrit-Jan Linker »  

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