ETL+ Source Driver for Microsoft Excel

Creates and manages Source Objects that connect to Microsoft Excel workbook files.

Source Objects panel button toolbar. Part of the ETL page.

Add Source: New Microsoft Excel connection.

Properties: Maintain Microsoft Excel connection.

Refresh: Update source Excel workbook metadata.

 

Interface to the Microsoft Excel source driver.

Microsoft Excel Page

 

Help

Change DataSource. Only shown when opened by Properties.

  • Connecting to Excel files with mapped drives. Problems have been reported when running ETL+ from the Agent.


How to Add Microsoft Excel Connections

  1. Open the https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 for the ETL+ entity to edit.

  2. Select Add Source > MS Excel.

For more see the Microsoft Excel Page section above or https://dataself.atlassian.net/wiki/spaces/DS/pages/1673560229

How to Maintain Microsoft Excel Connections

  1. Open the for the ETL+ entity to edit.

  2. Select a Microsoft Excel based Source Object on the Source Objects panel.

  3. Select Properties > MS Excel.

For more see the Microsoft Excel Page section above or or .

Software Requirements

The depends on a working Microsoft Access Database Engine.
If necessary, ETL+ will prompt you to install the Microsoft Access Database Engine.
For more about installing the engine see .


Position in the ETL+ Interface