HWA1_P5_2.sql

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

   PART 5.2
   Populate the ORGANIZATION table with the data provided
   (ORGANIZATION_data.txt) using the BULK INSERT command.
   ------------------------------------------------------------------------- */

USE DB9975
GO

BULK INSERT ORGANIZATION
	FROM 'T:\ORGANIZATION_data.txt'
	WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
GO