Import Data from .unl files to SQL Server

Rename the File to .txt


or




BULK INSERT dbo.table FROM 'C.\something\_something.unl'
WITH
(
DATAFILETYPE = 'char',
FIELDTERMINATOR = '#'
)