Use bulk copy to insert data into
an existing database table.
- In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select one or more tables in which to copy data.
If you select one table, you can select a different data file for each partition.
If you select multiple tables, you can only provide one data file for all partitions for the table.
- Select Bulk Copy In.
You see the Bulk Copy In wizard.
- In the Specify Data File window, enter the location.
- Select the format for copying data.
- In the Specify Copy Format window, choose the field and row parameters for the file to be copied into the table.