SQL Server/T-SQL Tutorial/Insert Delete Update/BULK INSERT

Using the BULK INSERT Statement

   <source lang="sql">

7> CREATE TABLE tTypes( 8> TypeID int NOT NULL PRIMARY KEY, 9> ManufacturerID int , 10> TypeName char (20) NOT NULL, 11> GrossWeight numeric (10,1) NOT NULL 12> ) 13> GO 1> BULK INSERT tTypes 2> FROM "C:\Types.txt" 3> WITH 4> (CHECK_CONSTRAINTS) 5> GO Msg 4860, Level 16, State 1, Server J\SQLEXPRESS, Line 1 Cannot bulk load. The file "C:\Types.txt" does not exist. 1> 2> --The default field delimiter is the tab character. 3> 4> drop table tTypes 5> GO 1></source>