Export Microsoft Access Field and Table Names to Excel

Do you work in Microsoft Access? Would you like to export information about your tables into an Excel file, perhaps to create a data dictionary?

Export Microsoft Access Field and Table Names to Excel

Do you work in Microsoft Access? Would you like to export information about your tables into an Excel file, perhaps to create a data dictionary?

Try this VBA script available on GitHub. Designed to document the tables in a Microsoft Access file, it will export a list of user-created fields with additional information such as table names, field types, field sizes, descriptions, captions, and row source. Available file output formats include MS Excel, PDF, Text, XML, and others. Sample output is listed in the article image above.

To run the script, open your MS Access database with macros enabled, paste the script into a new module, click on "exportAccessMetadata()", and hit <F5>. Known limitations: first, this script does not fully account for some of the newer and more unusual MS Access field types, such as "calculated." Second, field names may come out blank if they include unusual characters.

If you choose to use the script, please check its output to make sure it is what you expect. As a disclaimer, this code - like anything else on this site - is offered as-is for informational purposes only and with no guarantees or responsibility implied for the outcome. Use at your own risk.