Windows Forum

Ask something
Discussion Locked

Merging Access97 fields w/ Word97 table

0 helpful
6 replies

by c a stovall

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I've been trying to export the fields of an Access97 database table into a Word97 word processing table. I am highlighting the database table in Access97, clicking the Word integration icon, and choosing to link the data to an existing Word document (a Word97 table). But the result of the merge is a separate Word97 table for each record. What I want is a single Word97 table with each record being a row within that table.

My operating system is Microsoft Windows 98 4.10.1998

6 replies

by tmaclennan

Any reason you can't highlight the Access table, choose Edit/Copy, then Paste into an empty Word Document?

by mslizny

There are two options for linking to Word
from Access: Mail Merge and sending as
a text file.

If you want to use Mail Merge, are you
using the Word Mail Merge format of a
main document and a data source? In
this option you use field place holders to
indicate the location of each record in the
main document. This option expects that
you want separate results for each
record.

The second option is to send the
information to directly to Word. It sends
the informationover as a delimited-file,
which you can turn into a table in Word
using the menu command "Table, Turn
Text Into Table."

by mslizny

P.S. The second option is "Publish it with MS Word." It brings the info from Access in as a table.

This discussion is closed to new replies.