You want to import data from a Microsoft Excel file to analyze the data.
Configure a mapping task to use the insert operation. You use the following objects in the Microsoft Excel mapping:
Source object
The source object for a mapping task is a worksheet. Use the Microsoft Excel connection to connect to a Microsoft Excel file and read data from the Microsoft Excel file. The worksheet object is a single source in the mapping task.
Target object
Use a .csv file as the target object in the mapping task. The target in the mapping task is a flat file.
Mapping
Map the fields of the Microsoft Excel Worksheet source to the flat file target.
The following image shows the Microsoft Excel mapping:
When you run the mapping, the Secure Agent writes the data to the flat file based on the fields you mapped in the mapping task.
