Import csv file and return Table in Sql

Import csv file and return Table :



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

BULK
INSERT TestFROM 'c:\Nilay.txt'WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')GO--Check the content of the table.SELECT *FROM Test
GO