Fill Word table from external data source?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MelissaMcB - 10 Nov 2004 16:49 GMT

I have a series of Word documents that display detail about a single topic.
For one of those pieces of detail, an Access database contains the detail for
all topics (simple table that includes a column for topic name). This allows
us to view all the detail for a specific topic in one place, but also allows
us to view all the info for a specific detail data item across topics.

I don't want to update both places when a change is made. Is it possible to
keep the data in the Access database, then dynamically fill a table in each
Word doc with the detail for its specific topic when the Word doc is opened?

Reply to this Message

Perry - 10 Nov 2004 22:19 GMT

Hi MelissaMcB,

Here's an article dealing with getting data from an MS Access table.
http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

Try to adapt the code in yr situation, knowing that you can always fall back
to
the group if yr code fails.
In such case, startup a new thread and include relevant parts of the code
and indicate the MS Office version y're running (and OS)

Krgrds,
Perry

> I have a series of Word documents that display detail about a single topic.
> For one of those pieces of detail, an Access database contains the detail for
[quoted text clipped - 5 lines]
> keep the data in the Access database, then dynamically fill a table in each
> Word doc with the detail for its specific topic when the Word doc is opened?

Reply to this Message

MelissaMcB - 11 Nov 2004 13:42 GMT

Will do. Thanks for the link!

-Melissa

> Hi MelissaMcB,
>
[quoted text clipped - 26 lines]
> > Word doc with the detail for its specific topic when the Word doc is
> opened?

Reply to this Message