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 / January 2007

Tip: Looking for answers? Try searching our database.

Problems importing an Access 2003 Query into a Word 2003 File

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DJMoran - 21 Jan 2007 12:00 GMT
Hello all,

I'm having troube importing a query from microsoft access 2003 into a word
2003 document. I know how to do this in office 2000 (the version my school
uses) but i can't get it to work in office 2003 (my version).

At the moment i'm in a state of panic as this for my GCSE coursework and the
deadline was friday 19th but i have been given an extension to tomorrow
(22nd) due to this problem.

As i've said i cannot import a microsoft 2003 query into a microsoft word
2003 document. If i were to import the table however, it's a completely
different story. The table is imported successfully.

I can give only a few details of what i have to do due to this being
coursework.

1. I have a database premade
2. I have to make a query that works for both a report and a letter based on
the database -- Done
3. I have to make a report (using access) -- Done
4. I have to make a letter (using word) -- No Go

Office 2000 is perfect as it will import the query no problem, but
unfortunately i do not have access to this piece of software as my school is
closed on sundays and waiting until tomorrow is pointless as there is still 2
or more hours worth of work to do.

Any suggestions are greatly apprecciated and needed. Thank you.
Peter Jamieson - 21 Jan 2007 13:37 GMT
When you "imported a query" in Word 2000, do you mean that you used your
query as a data source for a Mail Merge, or something else? If something
else, can you spell out what you did in Word 2000?

If you're using Mailmerge...
By default, Word 2003 uses a different method (OLEDB) to connect to Access
data than Word 2000 did. OLEDB does not "see" all the queries (for example,
it does not see "parameter queries"), and queries that use wildcard
characters such as * and ? probably will not work as you expect either.  You
can change back to the old method (DDE) by checking Word
Tools|Options|General|"Confirm conversion at open", going therough the
process of connecting to Access again, and selecting the DDE option when it
is offered.

Peter Jamieson
> Hello all,
>
[quoted text clipped - 29 lines]
>
> Any suggestions are greatly apprecciated and needed. Thank you.
 
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.