Export Table Design Details to a Word Doc

M

MarkV

Hello everyone
I wish to export a table from Access and place it into a Word document. However, it is not the DATA I wish to display in the Word document, but some table design information i.e. Table name, Field names, Field sizes, etc. I also wish to see which fields are indexed and which field is the primary key.
Firstly, is possible to do this?
Secondly, can someone kindly tell me how?
I look forward to your reply. Many thanks in advance.
Mark
 
G

Greg Kraushaar

Two options
1. (Easy but Inflexible) Use the Database documentor to create a
report, then publish it to WOrd
2. (Harder, but you can do exactly what you want)
Open a New WOrd Document using OLE. Work through the Table design
using DAO structure. Insert the Info you are interested in directly
into the Word document and format it how you want.

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)
 
A

ALloydF

The Database Documentor is an add-in that produces a report on all (or a subset) of the objects in the database. Great tool, but I've just started a project using Access 97 (yeah, I know, nothing I can do about it), and I can't find the Documentor for download anywhere.
Does anyone know where I can get it now?
 
J

Joan Wild

It's part of Access 97; Tools, Analyze, Documenter. You may need to install
from CD if you didn't do a complete install

--
Joan Wild
Microsoft Access MVP

ALloydF said:
The Database Documentor is an add-in that produces a report on all (or a
subset) of the objects in the database. Great tool, but I've just started a
project using Access 97 (yeah, I know, nothing I can do about it), and I
can't find the Documentor for download anywhere.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top