View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
C Wood
 
Posts: n/a
Default Database into a table

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?