HWA1_P2_2.sql

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

   PART 2.2
   Create the bulk insert script to insert the PersonData.txt file.
   ------------------------------------------------------------------------- */

USE DB9975
GO

-- NOTE: I've used the SUBST command to assign the T: drive as the location
-- for my homework 1 project files.
--
-- e.g. C:\>SUBST T: \path\to\my\project\files

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