Thread
:
Database into a table
View Single Post
#
5
Posted to microsoft.public.word.mailmerge.fields
C Wood
Posts: n/a
Database into a table
That does the trick - thanks
"Peter Jamieson" wrote:
Yes, i don't know why it does that. Try nesting the DATABASE field inside a
SET field, e.g.
{ SET A { DATABASE your text } }
then put { A } or { REF A } in the table. It seems to work here.
Peter Jamieson
"C Wood" C
wrote in message
...
I am trying to setup a document that pulls data from Excel databases and
places the information into a table.
The fieldcode looks like this:
{DATABASE \d "T:\\Program Review\\Program Costs.XLS" \c "Entire
Spreadsheet"
\s "SELECT fte FROM T:\\Program Review\\Program Costs.XLS WHERE ((progid =
0201))"}
This works fine when it is used outside of a word table, but when I copy
the
field into a table, I get: Error! Not a valid result for table.
What I am trying to do is setup a table that pulls data for 4 years of
data
- each year in its own column.
Is there a better way to do this?
Reply With Quote