Results 1 to 4 of 4
  1. #1
    krag is offline Medium experience
    Windows 10 Access 2016
    Join Date
    May 2014
    Posts
    71

    Exporting list of table fields with data type and description to excel


    I need to make a user's manual for my application user and want to include just the list of table field names, data types and Descriptions as seen in the Table design view.
    Is there a way to export just this information (not the table field values), to excel?
    I can ofcourse export just the field names without field values from a query from that table.
    I need the data types and description also to go with that.
    Any help will be appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    try DATABASE TOOLS tab
    DATABASE DOCUMENTER

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can try this app I made for me to create a report of data definitions.

    Data Definition Maker.zipData Definition Maker.zip

  4. #4
    krag is offline Medium experience
    Windows 10 Access 2016
    Join Date
    May 2014
    Posts
    71

    Thumbs up

    ranman256
    Many thanks for simplifying my job.
    Exactly what I wanted.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 02-03-2017, 12:12 PM
  2. Exporting a database to Excel with list of attachments
    By TanyaF in forum Import/Export Data
    Replies: 3
    Last Post: 03-24-2016, 01:53 PM
  3. Access Pivot Table: losing Detail Data when Exporting to Excel
    By MichaelSchulz in forum Import/Export Data
    Replies: 7
    Last Post: 05-12-2015, 05:10 PM
  4. Replies: 4
    Last Post: 03-19-2015, 06:14 PM
  5. Replies: 1
    Last Post: 05-17-2010, 12:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums