Data transfer - Data source / Target "OpenOffice Calc Spreadsheet"
Here you will find the instructions for configuring a data transfer if you selected "OpenOffice Calc spreadsheet" as the type of the data source or the type of the data destination in the first step when creating the connection.
Source / Target - OpenOffice spreadsheet file
Select the file and the time zone here. The file must be stored in a directory that the server has access to.
Click "Next".
OpenOffice spreadsheet settings
Select the table here.
File contains headers
With this option, the first line is not imported but is used as the column title for the field assignment.
Ignore blank lines
Prevents blank lines from being imported.
Cell area
No range
Uses the entire table.
Range specified by coordinates
Enter the number of the first and last column and row, respectively.