Export table design

[Olivier Goossens Bara]

Is there any way to export a table design to ASCII or WORD or Excell

The purpose is to get the table definition in a more litteral description
document

Thank for any suggestion

 

[G. Vaught]

Why not use the built-in documenter in Access. This will define all the
structure of your tables. Look under Tools | Analyzer | Documenter

 

[Olivier Goossens Bara]

Unfortunately it is a build-in documenter

I realy need to use the table description Oustside ACCESS
Of course I can retype everything but this is tedious

I can also write a VBA macro to export every table description but I had the
hope to find some existing tool / way to do it.

 

[Tom Wickerath]

Olivier,

Why do you really need to obtain this information outside of Access? Why not use the documenter,
and then use File > Export when the documentation report is displayed. You can pick your flavor
of export, including an Excel spreadsheet, a text file, or a rich text document. This way, you
don't need to retype anything.

Tom
___________________________________________


Unfortunately it is a build-in documenter

I realy need to use the table description Oustside ACCESS
Of course I can retype everything but this is tedious

I can also write a VBA macro to export every table description but I had the
hope to find some existing tool / way to do it.


___________________________________________


Why not use the built-in documenter in Access. This will define all the
structure of your tables. Look under Tools | Analyzer | Documenter

___________________________________________


Is there any way to export a table design to ASCII or WORD or Excell

The purpose is to get the table definition in a more litteral description
document

Thank for any suggestion

 

[John Vinson]

Unfortunately it is a build-in documenter

I realy need to use the table description Oustside ACCESS
Of course I can retype everything but this is tedious

I can also write a VBA macro to export every table description but I had the
hope to find some existing tool / way to do it.

The documentor IS such a tool. You can Export the Report generated by
the documentor in HTML format and import that document into Word.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps