Adding a new data source to ETL+
Buttons on the ETL Source panel.
Example 1: Microsoft Excel Workbooks
Click on the +Cylinder to add another data source
Select which kind of data the source is.
Type the name of the data source and path to the source data.
For Excel sources, the path is to the specific filename.
The path can be a mapped drive or UNC path. After the path is correct, click on Connect.
For Excel data sources, a table will display for every visible worksheet tab in the workbook.
Example 2: CSV Files
For CSV & TXT sources, the path is to the folder containing the csv or txt file(s). Then click on Connect
For CSV & TXT sources, the path is to the folder containing the csv or txt file(s)
All the text files in the parent folder are added as ETL+ data source tables.
Related Pages
All Supported Data Sources
ETL+ Source Types (ETL Source panel) An overview of the types of data sources ETL+ can connect to.
ETL+ Source Types Details about the various data source drivers supported by ETL+.
Excel Data Sources
ETL+ Issues Importing from Excel A Microsoft driver largely determines how Excel data is extracted.