insert into
openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=D:\xsgl60\To',
'select * from [revisiond.dbf]')
select * from (
select item,item_no,cname,item_code,type,amount,uom,[user],createdate,lastdate,mgroup,valibdate,verdict,
auditing,imputa,cost,bomdate,nen_cost,err_nmark,en_cost,err_mark,bom_err
from revision) as tmp
这个为什么不行啊
服务器: 消息 7399,级别 16,状态 1,行 1
OLE DB 提供程序 'MSDASQL' 报错。提供程序报告了意外的灾难性错误。
[OLE/DB provider returned message: 不能更新查询,因为 FROM 子句不是单一的简单表名。]
/**************导入DBF文件****************/
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=e:\VFP98\data;
SourceType=DBF',
'select * from customer where country != "USA" order by country')
go