Bulk Insert - Read Txt File

BULK INSERT dbo.YourTableName FROM 'D:\directory\YourFileName.csv'WITH( CODEPAGE = '1252', FIELDTERMINATOR = ';', CHECK_CONSTRAINTS )

BULK INSERT dbo.temp FROM 'c:\temp\file.txt' WITH ( ROWTERMINATOR ='\n' )