You are here: Defining Files and Fields > Defining Access Database Tables

Defining Access Database Tables

From the File Format screen (Local or Windows Server), select the Access radio button and click [Next].

The ACCESS option treats all versions of MS Access databases as a relational database, allowing you to select join tables, select desired columns, and apply SQL Where and Order clauses. The result can be flattened or read directly.

Note: To read a specific version of an Access database using this option, the correct version of the Access driver must be installed on the relevant local machine or Arbutus Windows Server.

Select Tables

Select Columns

Specify Where and Order Clauses