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

Excel Data Sources