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 Functions

Buy now

Download now

SQL*XL online help
 

SQL*XL: Excel functions

Excel Functions

SQL*XL
home

A few SQL*XL functions are available as Excel worksheet functions. These can be typed in an Excel cell and the result is displayed just as a normal Excel function would do. To create an SQL*XL Excel function select the function from the Insert Function menu of SQL*XL.

The following SQL*XL Excel functions are available:

Command Description
SQLBindVariable Display the value of a database bind variable.
SQLCreateDeleteStatement Create an SQL delete statement.
SQLCreateInsertStatement Create an SQL insert statement.
SQLCreateUpdateStatement Create an SQL update statement.
SQLFunction Execute a database function and display the result.
SQLQueryValue Executes a select statement and display the result.
SQLSubstitutionVariable Display the value of a database substitution variable.

See also:

SQL*XL ribbon in Excel