[MSAccessProfessionals] Create a Data Dictionary for your Access database

hi everyone,

Create a Data Dictionary for your Access database, and write the results
to Excel

video:
Document Access Tables to Excel (10:16)
https://youtu.be/r6LRurruI44

code:
VBA > Document > Tables to Excel
http://msaccessgurus.com/VBA/Code/Document_Tables2Excel.htm

Creates an Excel workbook with the documentation. The first sheet,
ListOfTables, gives you the Table name, number of records, number of
fields, and also an estimated record width for the standard data types.

The DataDictionary sheet lists Table name, Field number, Field name,
Data Type, Size (byte), Description, Format, Caption, Default Value,
Expression, Input Mask, Validation Rule, Validation Text, Required,
Unicode Compression, and Estimated Width.

kind regards,
crystal

Remote Training and Programming
connect to me - let me help your project be a great success



-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116036): https://groups.io/g/MSAccessProfessionals/message/116036
Mute This Topic: https://groups.io/mt/85153347/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-