Settings for Microsoft Excel

This topic describes how to set up Excel for DataSync.

  1. In DataSync, create a new source connection for Excel.

  2. Fill out the fields in the New Connection dialog box as described below.

  3. Click Save.

Connection Properties Description
Description Enter a name for the source connection.
File Path Enter the local or network path of the Excel file (.xlsx or .xls).
Does your sheet contain headers? If your sheet contains headers, the first row will be used as column header. If not, unselect this option so that pseudo column names (A, B, C, etc.) can be used.
Read as empty Indicates whether to read empty values as empty or a null.
Verbosity

The verbosity level that determines the amount of detail included in the log file. Verbosity levels range from 1 to 5; the default is 3.