Online Documentation for SQL Manager for SQL server
Bulk Insert Wizard
Bulk Insert Wizard allows you to use the Transact-SQL BULK INSERT statement to load a data file into a database table / view in a user-specified format. This statement copies data from a file to a table, appending the records to already existing data in the table. The file must be accessible to the server and the filename must be specified from the point of view of the server. You can save your settings as a template any time for future use.
To start the wizard, right-click the table/view in DB Explorer, select the Data Manipulation context menu group and proceed to the 
Bulk Insert... item within this group.
Alternatively, you can open the Data tab of Table Editor / View Editor, right-click the grid there, then select the Data Manipulation context menu group and proceed to the Bulk Insert to <object_name>... item within this group, or use the Bulk Insert item of the Navigation bar.
- Selecting a table or view and the data file
- Setting bulk insert options
- Customizing data file format
- Viewing the result SQL statement
- Running bulk insert
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
