Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
DJMoran DJMoran is offline
external usenet poster
 
Posts: 1
Default Problems importing an Access 2003 Query into a Word 2003 File

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Problems importing an Access 2003 Query into a Word 2003 File

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
"DJMoran" wrote in message
...
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.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Why can't I get Multiple instances of word? Laverne Microsoft Word Help 14 November 17th 06 02:35 PM
Word & WordPerfect MrsMac Microsoft Word Help 5 June 10th 06 03:14 AM
How can Word display full path of a file in the title bar? SAsif Microsoft Word Help 1 January 26th 06 05:32 PM


All times are GMT +1. The time now is 02:58 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"