Data transfer - "Microsoft Excel" data source

Here you will find the instructions for configuring a data transfer if you selected "Microsoft Excel" as the type of data source in the first step when creating the connection.

Source - Microsoft Excel

A click on "Search" opens a dialog in which the source file can be selected. In both cases, the file must be stored in a directory released for the server. The time zone can also be changed here if date values are contained in the file.

Excel Spreadsheet Settings

Page

Select the table here.

File contains headers

The first line is not imported here, but used as a column title for the field assignment.

Ignore blank lines

Suppresses the import of empty lines.

Cell area

No range

Uses the entire table.

Range specified by coordinates

Enter the number of the first and last column and row, respectively.

Click "Next" to complete the configuration of the connection.

More information

Data transfer

Create connection

Target options

Transformation field mapping

Schedule

Subsequent jobs

Data transfer" application