Text Wizard Step 3

Use this Step to define the file you selected in Text Wizard Step 2 as a table. The top of the dialog box shows the properties of the file that is being defined and the bottom shows the table properties, including Table Name and Column Properties.

Column properties in the bottom of the dialog box are shown for the currently selected column header. Available properties depend on whether the file type you specified was comma, tab, fixed, or stream. See the table below for properties definitions.

Field Definition
File Properties
File Name File name of the data source

Type of text file: comma, tab, fixed, or stream.

Delimiter Character Character used as a delimiter in character-separated files. It can be any printable character. The default is a comma (,).
Decimal Symbol The decimal separator is a comma or a period used when data is stored. The international decimal symbol (.) must be used in DML statements and parameter buffers.
Column Names in First Line

Select this check box to indicate that column names are specified in the first line of the file.

Note: The Default Type, Delimiter Character, and Column Names in First Line settings apply only to tables not previously defined. These fields also determine the attributes of new tables created with the Create Table statement.

Table Attributes
Table Name Name of the selected table containing your source or target data.

Name of the column selected in the Column Information box.


Data type of the field: Varchar, Numeric, or Date.

If the field type is Date, you must enter or select a mask.

Mask Controls the format of date time fields, such as, dd-mm-yyyy produces a date formatted as 12-25-2014. Required when field type is Date.

Numeric data types — Maximum number of digits used by the data type of the column.

Character types — Length in characters of the data.

Binary data types — Length in bytes of the data.

Time, timestamp, and all interval data types — Number of characters in the character representation of the data.


Decimal and numeric data types — Maximum number of digits to the right of the decimal point.

Approximate floating point number columns — Scale is undefined because the number of digits to the right of the decimal point is not fixed.

Datetime or interval data containing a seconds component — Number of digits to the right of the decimal point in the seconds component.

Length In a fixed-length table, the number of bytes of data.
Offset In a fixed-length table, the number of bytes from the start of the table to the start of the field.

When you are finished, click Finish or click Back to return to Text Wizard Step 2.

The configured text data source is displayed in the Connect To Source dialog box, under the Text Files branch of ODBC Data Sources. Highlight the data source and click OK in the dialog box to begin configuring your Source or Target.