CREATE TABLE CSVTest
    (ID INT,
                FirstName VARCHAR(40),
                LastName VARCHAR(40),
                BirthDate SMALLDATETIME)




BULK 
INSERT CSVTest
        FROM 'c:\csvtest.txt'
            WITH
    (
                FIELDTERMINATOR = ',',
                ROWTERMINATOR = '\n'
    )