EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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 iconTools_BulkInsert 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 iconTools_BulkInsert Bulk Insert to <object_name>... item within this group, or use the iconTools_BulkInsert Bulk Insert item of the Navigation bar.

 

menuBulkInsert

 

 

 

 

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.

 

 


See also:

Export Data Wizard

Import Data Wizard

Export as SQL Script

Using templates