Microsoft Excel Connector Guide > Data Synchronization Tasks with Microsoft Excel > Microsoft Excel Source Data Synchronization Task Example

Microsoft Excel Source Data Synchronization Task Example

You want to import prospective inpatient payment details from a Microsoft Excel file to analyze the data.
Configure a Data Synchronization task with the insert operation and configure the following objects:
The source object for a Data Synchronization task corresponds to worksheets present in the Microsoft Excel file used for creating a connection. Use the Microsoft Excel source connection to connect to the Microsoft Excel file and read data from the worksheet.
Use a .csv file as the target object in the Data Synchronization task. The target object file must contain the tables you select in the source object.
Map the primary fields of the source object to the flat file target object.
The following image shows mapping of the fields:
Note: When you run the Data Synchronization task, the Secure Agent writes the retrieved tables to the target.CSV file.