Using BULK INSERT to Load a Text File
BULK INSERT
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.