Skip to main content
Skip table of contents

ETL+ for MS Access

Installation Checklist

Connecting to Microsoft Access

  • If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.

  • Login to ETL+ (help here).

  • Adding a new Access file: On ETL page’s left panel, click Add Source -> MS Access.

  • Maintaining an Access source: On ETL page’s left panel, right-click the Access source → Properties.

  • On the Microsoft Access page:

    • The Alias box will be automatically populated, but you can customize it.

    • File Path: Enter a local Access file or use Browse to find it.

    • Supported Access formats: MDB, ACCDB.

    • If applicable, enter the Password.

    • Click Connect.

  • You’ll get back to the ETL page and see tables under the selected Access source on the left panel.

Mapping and Loading Tables

  • To view tables available from an Access source on the left panel, right-click the Access source → Refresh.

  • To map an Access table to the data warehouse, double-click its name on the left panel, or right-click on it → Add Table.

    • You’ll now see the table added/mapped to the center panel.

  • To preview its data, right-click the table on the center panel → Preview.

  • To load its data to the data warehouse, right-click the table on the center panel → Load Now.

  • Click the Log icon (top right) to view data load results. Log page help here.

Schedule the Data Load

  • On the ETL main page, click Job (top right icon on the center panel).

  • The Job page usually comes pre-configured to your source system(s).

    • Overview this page’s configuration. On the right panel, feel free to uncheck tables and Tableau extracts that don’t apply to your reporting needs.

  • Run a Job now (optional): click the Run Job (play icon) on the left panel.

  • To schedule the data load (optional):

    • Select a JobJob Properties (wrench icon) → configure the schedule panel → Save

  • Click Close -> Close.

Testing

After ETL+ has loaded your Access files, this is to check if the data extraction process finished successfully and row count per extracted table matches with your Access tables.

Steps

  • Login to ETL+ (help here).

  • On the ETL main page, click the top-right Log icon. Log page help here.

  • Scroll down on the log page and double-check that no table load failed, and the row count matches with the Access tables. Following is an example highlighting two tables and their loaded row count.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.