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:
=sqlxl.xla!MergeField("empno")
You need to use the merge fields in your own spreadsheet template when doing
mail merges with your data set.
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
