TXT数据文件批量导入SQL Server2005

BULK INSERT Files

FROM 'c:\test.txt' 
WITH ( 
FIELDTERMINATOR = '\t', --字段间隔符号 
ROWTERMINATOR = '\n' --记录间隔符号 
)