Code

VBA: How to List Table Definitions in Access File

In this article, we will introduce code that converts a list of table definitions within Microsoft Office Access(アクセス) (.mdb) files into Oracle-compatible table definitions and outputs them as a list.

Overview

  • We will use Excel and VBA for this process.
  • By running the VBA function GetTableDefinitions, you can output a list of table definitions from an Access file to the open Excel sheet.
  • We will create text data intended to be pasted into a table definition document (.xls).
  • For Access tables converted to Oracle, text columns, for example, will be displayed as VARCHAR2.
  • We won’t output system tables (you can modify the code to include them if needed).
  • Link tables will display the contents of the links. The definitions of linked destination tables will not be output.

How to Use

  1. Open Excel.
  2. Open the Visual Basic Editor from the development tools.
  3. Add a module.
  4. Check Microsoft DAO in the Tools > References settings.
  5. Paste the code below.
  6. Execute the GetTableDefinitions function.
Continue reading VBA: How to List Table Definitions in Access File →