Fields tab

Use the Fields tab to define properties for the fields being exported.

Microsoft Access input step Fields tab

Option	Description
Name	The name of the output field.
Column	The name of the column in the Access table.
Type	The target data type to convert.
Format	The format or conversion mask to use in the data type conversion.
Length	The length of the output data type.
Precision	The precision of the output data type.
Currency	The currency symbol to use during data type conversion.
Decimal	The numeric decimal symbol to use during data type conversion.
Group	The numeric grouping symbol to use during data type conversion.
Trim type	The type of trimming to use during data type conversion.
Repeat	Select Yto repeat the column value of the previous row if the column value is empty (null)
Get fields	Click Get Fields to have the step populate the table with fields derived from the source file. All fields identified by this step are added to the table.