Table Design - Export Field Name, Data Type & Description

[Joe Z]

I was wondering if there is a way to export the Table Design Structure:

1) Field Name
2) Data Type
3) Description

Into a Spreadsheet.

I was able to do this a long time ago, but can't seem to remember. I'm using Access 2000.

Thanks!

Joe

 

[Pat Hartman]

Use the built in documenter to create a report. Then use the analyze with Excel button to export to Excel.

 

[Steve2003]

I have searched high and wide under field descritption but cannot find the answer so here we go......
Is there a way of populating a list box with the description text, it is the text you fill in next data type when you have a table in design view, decribing what the fields is for.


Many thanks

 

[Pat Hartman]

Unfortunately, the built in documentor doesn't display the description field. You will need to write code to read the fields collection of the tabledefs collection. I posted code to do this. Try searching for it. Or in Access help, look for collections to see the basic code I started with.