Table documentation

[ctaylor]

I am looking for a method to document a table within MS Access 2000. Preferably, I would like to create an Excel spreadsheet showing the field names in the first column, datatype in the second, and description in the third.

Any thoughts?

[qball]

One can easily extract useful info about the tables from Access.

I think you use Tools, Analyze, documenter, or something like that. There probably are easy hooks into Excel for the data, but you want schema(meta) info which is a little harder.

hope that helps...

[ctaylor]

Thanks for the assist. I tried the documenter before I posted this post. The documenter provided all sorts of information, but not in a format that was useful to me.

I did an import of MS Access field names into MS Excel, tranposed the data, and manually recreated all the validation rules and validation texts. (In my initial post, I wanted to export the description field because it summarized the validation rules and validation texts present on about 170 fields within the table.)

What I would like to do is learn another, more elegant, automated method of doing this.

[qball]

With Access??????

Sorry, real DBs, this stuff is fairly easy to determine. Called:

metadata
data dictionary
other names, I don't know...

Access is the limitation here...

Maybe not elegant, but I know one can use other tools to gain access to an Access DB.

Example, PHP, see:

http://www.php.net/manual/tw/faq.databases.php

There are 3rd party PHP tools to convert Access DBs, or maybe PHP DB drivers for Access. Found some before on the web...