Output Database Documenter Information to Word Format

[dhstein]

I'd like to get the output of the database documenter into Word (PDF would be
a second choice). I can create an xps document but not sure if that gets me
to where I want to be. Any suggestions are appreciated.

 

[Franz]

dhstein a écrit :

I'd like to get the output of the database documenter into Word (PDF would be
a second choice). I can create an xps document but not sure if that gets me
to where I want to be. Any suggestions are appreciated.

You can write a VBA program that read your DB and create a Word file.
You must add the reference to Office Word Objects, use a OpenFileDialog
to have the file destination and after in the Do-Loop cycle of recordset
you can write your document in your preferred format.
Bye.
Francesco

 

[dhstein]

Franz - thanks for your response but I'm talking about the database
documenter feature that's in Access 2007 (I don't know if was in previous
versions)

 

[geoleo68]

Once you run the documenter and the report comes up on screen you will get
bellow the menu bar the "Analyze with MS Word" icon (probably you might be
seeing the Excel icon but to the right there is a down arrow which will show
you a couple more options included the MS Word you require)

To have the output on PDF format I recomend you download the PDFill Writer
from http://www.pdfill.com/freewriter.html It's a completely free program
which will create a new PRINTER DRIVER named PDFill PDF Writer where you can
output any document into PDF format. If you install this program then you can
just print out the documenter report directly to the PDF printer and just
select the destination and name of your output file.

GeoLeo68