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
Select data from the database (Read 4525 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
http://www.oraxcel.com/projects/sqlxl/help/techniques/query/index.html
 
SQL*XL help files: Excel Oracle Query
http://www.oraxcel.com/projects/sqlxl/help/techniques/query/oracle.html
 
SQL*XL help files: SQLQueryValue  
http://www.oraxcel.com/projects/sqlxl/help/functions/sqlqueryvalue.html
 
SQLQueryValue as Array formula  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1162290970
 
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)
http://www.oraxcel.com/projects/sqlxl/help/dialogs/resultset_options/target.html
 
How to attach query results to a pivot table  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1163601907
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