Export/Copy field properties to Excel

[paulhenley]

I need to list all fields within each table and include each of the fields properties ie Field Name, Data Type, Description, Field Size, Indexed etc, etc.

I would like to do this in Excel - is there a way to get this data?

Any help would be greatly appreciated

 

[Pat Hartman]

You can use the database documentor to document the tables and then export the documentation to Excel. You need to look at the options available for each object type so that you can select the properties you want.

 

[IMO]

Go to Tools >> Analyze >> Documenter and select the tables, forms etc that you want documented. Once the snapshot has been created go to File >> Export and select Text Files. After the file name put .csv

IMO

 

[paulhenley]

Thank you all for your help - I'm nearly there. I have tried many different options but cannot quite get what I require. What I would like is all the property names as columns across the spreadsheet with values for each field in each row. Is there a way of achieving this?

Perhaps it is just my poor Excel skills.

Many thanks