Skip to main content
Skip table of contents

ETL+ Source Driver for Microsoft Excel

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

image-20250129-004945.png

Source Objects panel toolbar, ETL+ Extract, Transform and Load (ETL) Page

Add Source: New Microsoft Excel connection.

Properties: Maintain Microsoft Excel connection.

Refresh: Update source Excel workbook metadata.

Where to Find in ETL+

Interface to the Microsoft Excel source driver.

Microsoft Excel Page

Example configured to connect to local file BadDatesXLS.xls

  • Alias: The name for the source object shown on the Source Objects panel. Unless customized the name will be automatically populated from the File Path.

  • File Path: Full file reference to the Microsoft Excel workbook file.
    To connect to files on a network see also Source Driver File Path for Network Files.

  • Browse: File browser window.

  • Back. Leave the page without saving or attempting to connect.

  • Connect. Connect to the Excel workbook.

    • Same function as Refresh.

  • Save. Save the configuration without attempting to connect.

Help

Change DataSource. Only shown when opened by Properties.

NOTES

How to Add Microsoft Excel Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select Add Source > MS Excel.

For more see the Microsoft Excel Page section above or ETL+ for MS Excel

How to Maintain Microsoft Excel Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page 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 ETL+ for MS Excel.

Software Requirements

The ETL+ Source Driver for Microsoft Excel depends on a working Microsoft Access Database Engine.
If necessary, ETL+ will prompt you to install the Microsoft Access Database Engine.

See Access Database Engine: Required for ETL+ Excel, .csv & MS Access for how to verify if the engine is installed and how to manually download and install it.


Related Pages

Position in the ETL+ Interface

JavaScript errors detected

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

If this problem persists, please contact our support.