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
Execute a SQL statement directly from a function (Read 2566 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Execute a SQL statement directly from a function
09.01.06 at 08:26:25
 
Thou from Signapore asked the following question:
 
Question:
Can I execute a SQL statement directly from a function within a cell in Excel?
 
Answer:
Yes you can. If the statement is a select statement you can use the SQLQueryValue function. If you want to use another statement, e.g. an insert or update SQL command, you can use the SQLExecute function. Note that for both functions a Volatile function is available too (e.g. SQLQueryValueVolatile). The Volatile functions will always execute when Excel calculates.
 
See:
SQLQueryValue:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135155904
Back to top
 
« Last Edit: 09.01.06 at 08:26:57 by Gerrit-Jan Linker »  

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