SQL-Life: Import Data from .unl files to SQL Server

Showing posts with label Import Data from .unl files to SQL Server. Show all posts

Thursday, April 26, 2012

Rename the File to .txt

or

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