Unable to merge Access table into Word document

[Dennis]

I am attempting to merge an Access table into Word. I can import a static
copy of the table, but if I try to link the data fields by placing a check in
the checkbox titled "Insert data s field", so the tqable can be updated and
retain its formatting, I get the error "This operation cannot be completed
because of dialog or engine failure. Plese try again later." followed by the
error message in a second window "Word unable to open data source".
Both Word and Access are office 2003. I have Compacted/Repaired the DB with
no change. Anyone have any ideas. BTW, I successfully merged another table
from a different DB using that checkbox option. Can I perform this using VB
code and if so, I would need a little help with the code. A bit rusty in that
area. Thanks.

 

[Cindy M.]

Hi =?Utf-8?B?RGVubmlz?=,

I am attempting to merge an Access table into Word. I can import a static
copy of the table, but if I try to link the data fields by placing a check in
the checkbox titled "Insert data s field", so the tqable can be updated and
retain its formatting, I get the error "This operation cannot be completed
because of dialog or engine failure. Plese try again later." followed by the
error message in a second window "Word unable to open data source".
Both Word and Access are office 2003. I have Compacted/Repaired the DB with
no change. Anyone have any ideas. BTW, I successfully merged another table
from a different DB using that checkbox option. Can I perform this using VB
code and if so, I would need a little help with the code. A bit rusty in that
area.

Start by working through this Knowledge Base article. Even though it's written
for mail merge, Word uses the same data connection method for inserting/linking
to databases.

If that doesn't clear up the problem, then it would be worthwhile to try with a
different data connection method than the default OLE DB. In my experience, the
connection strings are sometimes to long to be stored in the Insert/Database
field. In order to choose a different connection method (my preference is ODBC),
activate "Confirm conversions on open" in Tools/Options/General. This will offer
you a list of available connection methods after you choose the database file.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Dennis]

Thank You. The OBDC process worked.

Hi =?Utf-8?B?RGVubmlz?=,

Start by working through this Knowledge Base article. Even though it's written
for mail merge, Word uses the same data connection method for inserting/linking
to databases.

If that doesn't clear up the problem, then it would be worthwhile to try with a
different data connection method than the default OLE DB. In my experience, the
connection strings are sometimes to long to be stored in the Insert/Database
field. In order to choose a different connection method (my preference is ODBC),
activate "Confirm conversions on open" in Tools/Options/General. This will offer
you a list of available connection methods after you choose the database file.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail