Each table column will contain a header row to help you sort and filter your data efficiently. The Insert Command. Open the Excel worksheet that contains your data table.

To drop any columns in the new table, you can specify the DROP= data set option in the CREATE TABLE statement. The specified columns are dropped when the table is created. Indexes are not copied to ...