Exporting table structure with description fields

[ljh3rdid]

Is there a non-manual way to export a table structure to excel format without
loosing the field descriptions?

Thanks in advance!

 

[Duane Hookom]

There is method using results from Tools->Analyze->Documenter. The
documenter creates a table in a wizard mdt file that you can link to. This
is explained at http://www.access.hookom.net/Documenter/. One of the queries
at this page shows all of the field properties.

 

[Jeff Conrad]

How about just a couple of mouse clicks?
Try my free add-in that does this:

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html

For 15 other options (including Duane's) see this page:

http://home.bendbroadband.com/conradsystems/accessjunkie/doctable.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: