create proc ImportData
@Path nvarchar(512),
@FileName nvarchar(512)
as
begin
set @FileName=replace(@FileName,'.','#')
exec ('select * from opendatasource(''MICROSOFT.JET.OLEDB.4.0'',''Text;HDR=Yes;DATABASE='+@Path+''')...'+@FileName)
endexec ImportData 'e:\','a.txt'ok了就给分 ,谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货