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.