Fill Word table from external data source?

[MelissaMcB]

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?

 

[Perry]

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
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?

 

[MelissaMcB]

Will do. Thanks for the link!

-Melissa

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


opened?