--生成临时表select * into tp from hisdata..view_ba_jbzl--再用下面语句,还有问题?用表应该没有问题,以前用过insert into openrowset('MSDASQL','DRIVER=Microsoft Visual FoxPro Driver;SourceType=DBF;SOURCEDB=D:\','SELECT zyh,Y1,Y4,Y5,Y8,Y9 FROM [L05.DBF]') SELECT zyh,Y1,Y4,Y5,Y8,Y9 from hisdata..tp
into tp
from hisdata..view_ba_jbzl--再用下面语句,还有问题?用表应该没有问题,以前用过insert into
openrowset('MSDASQL','DRIVER=Microsoft Visual FoxPro Driver;SourceType=DBF;SOURCEDB=D:\','SELECT zyh,Y1,Y4,Y5,Y8,Y9 FROM [L05.DBF]')
SELECT zyh,Y1,Y4,Y5,Y8,Y9 from hisdata..tp