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
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