How can I convert an Access database file into a Word Document?

#1 (**permalink**) 28-Jul-2006, 08:32 AM

I am compiling a large journal index in Access 2003. On completion I wish to
convert it to a Word document so that it can be edited to look like a
conventional book index. Export/Import simply copies the whole thing with all
the lines. Is there a way of moving the text only?

Chris H.

*

#2 (**permalink**) 28-Jul-2006, 08:32 AM

You can build an Access columnar report which will look like an index. You
can ouput Access data to a Word document using automation, or even the menu
option: Tools ... Office Links ... Publish it with Word.

Do not, under any condition ever open an Access database in Word (or
anything else which might autosave) if Word saves it, it will be corrupted
beyond repair.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12831-how-can-i-convert-access-database.html
http://www.mvps.org/access

"Chris Hicks, Bookbinder" Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12831
Bookbinder@discussions.microsoft.com> wrote in message
news:CB82D9F9-B8D9-4C40-B784-58FA38E2D018@microsoft.com...
>I am compiling a large journal index in Access 2003. On completion I wish
>to
> convert it to a Word document so that it can be edited to look like a
> conventional book index. Export/Import simply copies the whole thing with
> all
> the lines. Is there a way of moving the text only?
>
> Chris H.

#3 (**permalink**) 28-Jul-2006, 08:32 AM

Thanks for the suggestion but the result is still like a database table and
does not allow me to edit the text so that it resembles a conventional book
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12831
index with duplications of phrases removed.
Chris H.

"Arvin Meyer [MVP]" wrote:

> You can build an Access columnar report which will look like an index. You
> can ouput Access data to a Word document using automation, or even the menu
> option: Tools ... Office Links ... Publish it with Word.
>
> Do not, under any condition ever open an Access database in Word (or
> anything else which might autosave) if Word saves it, it will be corrupted
> beyond repair.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12831
> http://www.mvps.org/access
>
> "Chris Hicks, Bookbinder" > Bookbinder@discussions.microsoft.com> wrote in message
> news:CB82D9F9-B8D9-4C40-B784-58FA38E2D018@microsoft.com...
> >I am compiling a large journal index in Access 2003. On completion I wish
> >to
> > convert it to a Word document so that it can be edited to look like a
> > conventional book index. Export/Import simply copies the whole thing with
> > all
> > the lines. Is there a way of moving the text only?
> >
> > Chris H.
>
>
>