update a
set a.avg_cost=b.gprice
FROM
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="e:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...partflowbak$ a,
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="F:\jufan\dbf";User ID=Admin;Password=;Extended properties=dBase 5.0')...ovrdo b
where a.mano=b.mano
and (b.dono='' or b.dono is null)
用ovrdo表里的gprice更新EXCEL表里的avg_cost,路径什么的都不会有错,但一直提示出错,“对象名a无效”,我想是excel的SQL语法稍有些不同,有人知道吗?