把.txt文本中的数据导入到mssqlserver怎么做

（帐号）    （密码） 
asdfasdfas    123123123 
dfdsgsdfgf    123312312 

[1.txt]
colnameheader=true
format=delimited（    )
maxscanrows=0
characterset = ansi
col1="username" char width 32
col2="password" char width 32

select * from opendatasource（'microsoft.jet.oledb.4.0','data source="c:\documents and settings\administrator\桌面";user id=admin;password=;extended properties=text')...[1#txt]
--or
select * from openrowset（'microsoft.jet.oledb.4.0','text;database=c:\documents and settings\administrator\桌面',[1#txt])

insert into table （xxx,yyy,username,[password]) select u.xxx,u.yyy,t.username,t.[password] from [utable] u inner join （openrowset（'microsoft.jet.oledb.4.0','text;database=c:\documents and settings\administrator\桌面',[1#txt])) t on t.username=u.username