Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL video demos

Related LIT software: litLIB: Excel power functions pack ExcelLock: Locks and secures your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Demos

Buy now

Download now

SQL*XL video demos
 

SQL*XL: Database query cell formula.

Database query cell formula

In this demo SQL*XL's SQLQueryValue formula will be demonestrated. It binds a query result to a cell.

 

I will query the currencies table (columns code and description) to lookup the description for a currency code. The needed SQL is: select description from currencies .

 

To retrieve the description for the correct currency code the following where clause is added. Note the use of the concatenation operator & and that we need to wrap the code in single quotes:

"select description from currencies where code = '" & A1 & "'"

 

After creating one formula, simply copy it down so it works on the other source cells too.