ETL+ Source Driver for Microsoft Excel
Creates and manages Source Objects that connect to Microsoft Excel workbook files.
Add Source: New Microsoft Excel connection.
Properties: Maintain Microsoft Excel connection.
Refresh: Update source Excel workbook metadata.
Microsoft Excel Page
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 https://dataself.atlassian.net/wiki/spaces/DS/pages/2045575186.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. |
Connecting to Excel files with mapped drives. Problems have been reported when running ETL+ from the Agent.
How to Add Microsoft Excel Connections
Open the https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 for the ETL+ entity to edit.
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
Open the for the ETL+ entity to edit.
Select a Microsoft Excel based Source Object on the Source Objects panel.
Select Properties > MS Excel.
For more see the Microsoft Excel Page section above or or .
Related Pages
– – a tutorial on extracting Excel database tables into a data warehouse.
To connect to network drives or files.
Position in the ETL+ Interface
Extract, Transform and Load (ETL) page
Add Source, Properties or Refresh buttons