select 帐号=left(F1,12),密码=right(F1,6)
into 表
from(
select F1=cast(cast(F1 as bigint) as varchar)
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;FMT=Delimited;HDR=no;IMEX=2;CharacterSet=936;DATABASE=C:\'
,a#txt)
) a
insert into 表(帐号,密码)
select 帐号=left(F1,12),密码=right(F1,6)
from(
select F1=cast(cast(F1 as bigint) as varchar)
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;FMT=Delimited;HDR=no;IMEX=2;CharacterSet=936;DATABASE=C:\'
,a#txt)
) a