Import

Links

• Using BULK INSERT to Load a Text File

• BULK INSERT

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.