Supplying access data to word

[JoeElla]

Cindy,
First of all I am using both Access97 and Access 2000 (not at the same
time), and I am using Excel and word 2000. I can get the MSQuery to return
the records that I want returned, but not into my word document. When I
attempt to exit MSQuery and return to word I then get the message that ODBC
cannot connect to the database (it has already connected, I can see the data
in MSQuery).

Biff,
I am trying to use mail merge, but first I must connect to the data base,
and that is where I am having my problem.

I am beginning to think that there is something missing from my word
install.

 

[Peter Jamieson]

I am trying to use mail merge, but first I must connect to the data
base,

and that is where I am having my problem.

If you just need the data from a single table or existing Access query,
perhaps with some simple sorting and filtering, then typically you do not
need to go via MS Query - instead, in the Open Data Source dialog box, check
"Select method", then chose the Access via ODBC option when prompted. Then
you may need to click the options button in the dialog box that appears and
check all the options to see all the tables and queries.

If you need to define your own query, it may be easier to do it in MS Access
then connect to that query using the above method. As Cindy mentioned, there
is a problem with Word + MS Query if the Query is long - sure, MS Query
itself can get the data and return it, but Word actually tries to get the
data directly itself, and may not be able to do so if it has truncated the
SQL query text. Also, there can be problems with the connection string that
MS Query returns - it can be easier to use Word VBA to specify the data
source name, connection string, and query (I can provide more info about
this if you need it).