create table #temp(bbb char(20))
bulk insert #temp
from 'C:\mydata\book1.txt'insert table1(bbb)
select bbb from #tempdrop table #temp
bulk insert #temp
from 'C:\mydata\book1.txt'insert table1(bbb)
select bbb from #tempdrop table #temp
goinsert tabel(bb)
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=NO;DATABASE=C:\mydata\',book1#txt)