Importing columns using the Location method

Use the Columns page of the Import notebook with the Location (method L) radio button selected to import columns from nondelimited ASCII format (ASC) input files to the target table. The starting and ending locations of the data column in the input file are used as the mapping method.

Fields and controls

Authorities and privileges

To import columns using the location method:

1. Open the Import notebook, specify options on the File page, and open the Columns page.
2. Click on the Location radio button in the Include columns by box.
3. Select a column in the Table column box.
4. Click on the Change push button and change the column values.
5. Repeat steps 3 and 4 for every column.
6. If the table contains an identity column, use the Identity column behavior drop-down list to specify how you want data loaded into that column.
7. If the table contains one or more generated columns, use the Generated column behavior drop-down list to specify how you want data to be loaded into those columns.
8. Click on OK. The import process begins.

Related information

• Import -- Overview
• Using default settings (method D)
• Mapping column positions (method P)
• Mapping column names (method N)
• Specifying the target table and columns when creating a table