HWA1_P4_2.sql

/* -------------------------------------------------------------------------
   Yu Cheng
   ICS 321 Assignment 1
   September 18, 2008

   PART 4.2
   Populate the BILLET table with the data provided (BILLET_data.txt) using
   the BULK INSERT command. 
   ------------------------------------------------------------------------- */

USE DB9975
GO

BULK INSERT BILLET
	FROM 'T:\BILLET_data.txt'
	WITH ( FIELDTERMINATOR = ';', ROWTERMINATOR = '\n' )
GO