Import Database table to Word

  • Thread starter Thread starter David Williams
  • Start date Start date
D

David Williams

Hi. I have posted this query in a Word Newsgroup with no
luck. I am trying to import a database as a table into a
Word document using the Insert Database button in Word and
remove some fields during the import. I was under the
impression that during the import if I selected query
options, then select fields, that I could remove the
unwanted fields from the selceted fields list. However, it
doesn't work. All the fields are imported. Can anyone tell
me if what I am trying should work, and, if so, what I am
doing wrong.

David.
 
David said:
Hi. I have posted this query in a Word Newsgroup with no
luck. I am trying to import a database as a table into a
Word document using the Insert Database button in Word and
remove some fields during the import. I was under the
impression that during the import if I selected query
options, then select fields, that I could remove the
unwanted fields from the selceted fields list. However, it
doesn't work. All the fields are imported. Can anyone tell
me if what I am trying should work, and, if so, what I am
doing wrong.

David.
Click to expand...

Create a query in Access that will give you the fields you need.
Open Word and go to Tools/Mail Merge.
1. Create

2. Get Data (select the type of form you want.)
Open Data Source
Select your Access MDB
Click Open
Click the tab "query"
Select your query
Click ok
You will get a message box, click "Edit Main Document"
At this point word will open a new toolbar.
The first item will be "Insert Merged Fields".
Clicking this button will give you a drop down list of the fields from
your Access query.
Insert the fields you want, do any formatting needed, and saveAS the
new Document.

After you have saved the new document reopen it.

3. Go to Tools/Mail Merge and step 3.
Click merge

This will merge the data from Access into your word document.
Save this document with a new name so you don't overwrite your new
merge template.
This will allow you to use the template over again.

When you are doing the "Insert Merge Fields", you will need to do any
formatting
in the Word document, such as spacing, returns, or adding any comments
or text.

I hope this is what you are looking for.

Ron
--

Ronald W. Roberts
Roberts Communication
(e-mail address removed)
To reply remove "_at_robcom_dot_com"
 
I have a related problem which maybe you could help me
with Ron. When I merge to Word, dates appear as dd/mm/yy
00:00:00. No matter how I format them in Access, when
merged to Word they appear as shown and I think you'll
agree that a Word Document that says "Date of Birth:"
followed by "12/02/46 00:00:00" looks a little silly.
I'm wondering whether it's because I'm using Access 2003
in an Office 97 environment ie merging to Word 97.

Any offers?

Regards
David Kennedy
Scotland
 
Back
Top