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 Menu items

Buy now

Download now

SQL*XL online help

SQL*XL: Insert Merge Field

Insert Merge Field


The last retrieved data set (result from executing a select statement) remains available in Excel. Using the insert merge field menu you can create Excel formulas that retrieve the current value for one of the columns in the data set. In the menu there will be an item for each column in the data set as well as a button to create a small table with a formula for all columns.

An example of the merge field formula:


You need to use the merge fields in your own spreadsheet template when doing mail merges with your data set.

See also:

SQL*XL ribbon in Excel