SQL查询分析器SQL语句导入TXT文件

前提在D盘下建一aa.txt文档里面输入几个数据 每个数据占用一行create table test(num int not null)insert into test select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Text;HDR=NO;DATABASE=D:\' ,aa#txt)select * from testdelete test启用Ad Hoc Distributed Queries：exec sp_configure 'show advanced options',1reconfigureexec sp_configure 'Ad Hoc Distributed Queries',1reconfigure使用完成后，关闭Ad Hoc Distributed Queries：exec sp_configure 'Ad Hoc Distributed Queries',0reconfigureexec sp_configure 'show advanced options',0reconfigure