Word Tables and Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrsjoan - 18 Oct 2004 14:01 GMT

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?

Reply to this Message

Jezebel - 18 Oct 2004 22:24 GMT

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.

> 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
[quoted text clipped - 8 lines]
>
> Can this be done?

Reply to this Message