Loading data from a .data file to a table

You can load data from a .data file into a table.

Procedure

To load data from a .data file to a table:

  1. Right-click a table in the Data Source Explorer, and click Data > Load. If you are in the Object List, right-click the table, and click Load > With SQL. The Load Data window opens.
  2. Specify the name and location of a .data file on the file system, and specify whether to replace existing data.
  3. Click Finish.

Results

The data from the .data file is loaded into the table that you specified, and the results of the load operation are displayed in the SQL Results view.

Feedback