Specify Sort Order
Use this dialog box to order the records to be placed as they are placed in the destination table.
Options
Selected columns
View the columns to be copied into the destination table. To see the column in the Sorting order table, highlight a row and double-click, or click the > button.
Sorting order
View the columns to be used as the sorting criteria. An ORDER BY clause will be generated from the chosen columns. The ORDER BY clause will be followed by the column names shown in the Sorting order table, with the first column as the outer sort field, the next column as the inner sort, and so on. As a result, the records will be placed in the destination table in order of the specified sort. The ordering does not generate a clustered index or affect indexing.