BULK Insert from text file

CREATE TABLE #_txtrow  (_txtrow varchar(5000));

BULK INSERT #_txtrow From 'H:\<folder name>\filename.extension' 
WITH(DATAFILETYPE = 'char',ROWTERMINATOR = 'n');
SELECT * FROM #_txtrow

DROP TABLE #_txtrow

Leave a Reply

Your email address will not be published. Required fields are marked *