Word Tables and Access DB

[mrsjoan]

I have an existing Access DB and an existing WORD Table. I want to merge
specific fields from a query in the database and place it into specific
fields on the WORD table. I also want the database to be linked to the WORD
table so each time the Database is updated, the WORD table updates.

I have tried this from WORD using the database toolbar making sure I check
MSQuery but each time I get an error that says "To few parameters. Epxected
2". If I don't select MSQuery then I get all the data from the query and
have to do lots of cleanup in the WORD table--and this does not link it back
to the Access DB.

Can this be done?

 

[Jezebel]

The first part is easy ... just be persistent with your queries until you
don't get errors and your query returns only the data you need. Getting the
Word document to update everytime the database changes is trickier. For
this, you really need to do the work at the Access end, rather than in Word.