Supplying Access data to Word

[JoeElla]

OK I AM STUPID.

I have tried for far more time than I care to admit to use MSQuery to insert
Access data into a Word document. I am able to accomplish the task in
Excel, but no luck with word. After I create my data source, and then my
query, and when I attempt to return to my word document the message reads
"Word cannot connect to database". I have even tried using a query that I
created while in Excel and so I know that it works. I must be missing some
simple little step, but I have no idea what it is. Please help me.

 

[Cindy M -WordMVP-]

Hi JoeElla,

I have tried for far more time than I care to admit to use MSQuery to insert
Access data into a Word document. I am able to accomplish the task in
Excel, but no luck with word. After I create my data source, and then my
query, and when I attempt to return to my word document the message reads
"Word cannot connect to database". I have even tried using a query that I
created while in Excel and so I know that it works.

We always need to know the version of Word involved.

what is the data source type you're using MS Query to link to?

While in MS Query, click the button that displays the SQL view
(SELECT...FROM...WHERE). Are there a lot of characters in the SQL statement?
More than 255? Word is not able to accept an SQL statement of more than 255
characters from MS Query.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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

 

[biff]

Why don't you use Mail Merge?