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
Select data from the database (Read 4480 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Select data from the database
31.05.07 at 00:08:17
Select data from the database
To select data from the database into Excel SQL needs to be sent to the database. This is done through a SQL select statement, sometimes called a query.  
SQL queries are usually run from the SQL dialog. If required the SQL*XL SQL editor can be started in this dialog to help further to create the SQL. A database tables navigator is included in the SQL editor and template SQL can be generated by right clicking the table name.
There is also the possibility to retrieve database data into Excel through formulas. The SQL*XL SQLQueryValue forumula can be used to do this. You would use this SQLQueryValue worksheet function to make BI dashboards or BI cockpits in Excel.
Related topics on running queries:
SQL*XL help files: Excel database query
SQL*XL help files: Excel Oracle Query
SQL*XL help files: SQLQueryValue
SQLQueryValue as Array formula
The results of a query can be put in Excel, Word or other output targets. The Resultset dialog is used to take your choice of options.
Related topics on output targets:
SQL*XL help: Target Options (Resultset options dialog)
How to attach query results to a pivot table
Back to top
« Last Edit: 01.06.07 at 13:12:42 by Gerrit-Jan Linker »  

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