Using Word to print out a SQL DB table and format it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 28 Sep 2004 21:13 GMT

I was wondering if it is possible in word to retrieve data
from a SQL 2K database and format it to print out. I have
a eCommerce database with graphics and text and want to
print out a catalog of items using word. Can this be
done? Has anybody done this yet?

Thanks, Kevin

Reply to this Message

Cindy M -WordMVP- - 30 Sep 2004 16:18 GMT

Hi Kevin,

> I was wondering if it is possible in word to retrieve data
> from a SQL 2K database and format it to print out. I have
> a eCommerce database with graphics and text and want to
> print out a catalog of items using word. Can this be
> done?

The Insert Database command in the Data toolbar can insert a
table of data, but only textual data, no graphics or other
objects.

Similarly, you can use mail merge to bring database data into
a Word document. But the same restriction applies to anything
that's not pure text. With mail merge, however, if you have
the graphics saved to disk, with filename in the data table,
you can use this field name in an IncludePicture field to
display the graphics in the merge result. Instructions for
this are in the mail merge FAQ on my website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message