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
Assemble SQL in Excel (Read 3488 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Assemble SQL in Excel
03.06.07 at 22:27:19
 
Assemble SQL in Excel
 
It is possible using SQL*XL to make dynamic SQL from values stored in the the spreadsheet. SQL*XL can not only take SQL types into the SQL dialog but it can also read the SQL from a block of cells. To use this feature simply select a range of cells and start the SQL dialog. The option source should now be set to take SQL from the worksheet.
 
SQL may be written in a single Excel cell or be scattered among different cells. If Excel formulas are used only the result of the formula will be used. Excel formulas can be used e.g. to do string contatenation (=concatenate funtion) or to e.g. determine the current date or to format a date cell value into a date string (=Text( A1 , "dd-mm-yyyy") or to find the current location in the sheet (=Row() , =Column() )
 
A shorthand for string concatenation exists: the emparsand. Use ="selet * from " & "second" as formula and you will see both strings concatenated.  
 
Related topics:
Back to top
 
« Last Edit: 04.06.07 at 07:18:22 by Gerrit-Jan Linker »  

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