Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2003

Tip: Looking for answers? Try searching our database.

Supplying access data to word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JoeElla - 19 Nov 2003 17:13 GMT
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 - 20 Nov 2003 01:21 GMT
>    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).

--
Peter Jamieson - Word MVP

> Cindy,
>    First of all I am using both Access97 and Access 2000 (not at the same
[quoted text clipped - 10 lines]
> I am beginning to think that there is something missing from my word
> install.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.