You can load data from a .data file into a table.
Procedure
To load data from a .data file to a table:
- Right-click a table in the Data Source Explorer,
and click . If you are in the Object List,
right-click the table, and click . The Load
Data window opens.
- Specify the name and location of a .data file on the file
system, and specify whether to replace existing data.
- 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.