Import
Links
Sample
BULK INSERT table_name FROM 'C:\wip\codes.out'
BULK INSERT codes
FROM 'E:\codes\codes_1.txt'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
BATCHSIZE = 1000000
)
Note: Also see SQL Server Express, DTS, Express.