Page Comparison

Anchor
driverPage driverPage

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 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.

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.

Related Pages

• ETL+ for MS Excel – – a tutorial on extracting Excel database tables into a data warehouse.

• Source Objects panel

• Target Objects panel

• Extract SQL Statement panel

• Access Database Engine: Required for ETL+ Excel, .csv & MS Access

• Source driver File Path for Network Files To connect to network drives or files.

Anchor
UIPosition UIPosition

Position in the ETL+ Interface

• Extract, Transform and Load (ETL) page

  • Source Objects panel

    • Add Source, Properties or Refresh buttons