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

Using the BULK INSERT Statement

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>