Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Database into a table
Actually, what I am trying to do is pull specific records into different
documents. For example, I have a database of college programs with various data such as enrollment, etc. I then have a Word document for each specific college program that needs to pull the data from the database for that pariticular program, and hence my use of the SQL statement "Doug Robbins - Word MVP" wrote: Maybe just use a catalog (or in XP and later a directory) type mailmerge main documnet in which you have a one row table with the mergefields in the cells of that row. When you execute the merge to a new document, it will contain a table with a row of data for each record in the data source. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Database into a table
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? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Table AutoFormat... | Page Layout | |||
20x20 multiplication table | Tables | |||
Table headers/footers and layout | Page Layout | |||
Table AutoFormats vs. Table Styles confusion | Tables | |||
User-defined table format using Database field code | Mailmerge |