我想在mssql中修改excel数据,提示错误“对象名x无效”,语句如下UPDATE x
SET x.大项代码 = u.f_code
FROM OPENDATASOURCE ('MICROSOFT.JET.OLEDB.4.0',
'Data Source="D:\成绩统计.xls";
User ID=;Password=;Extended properties=Excel 5.0'
)...[成绩录入$] x , BAS_BigItem u
where (x.项目 = u.f_name)
SET x.大项代码 = u.f_code
FROM OPENDATASOURCE ('MICROSOFT.JET.OLEDB.4.0',
'Data Source="D:\成绩统计.xls";
User ID=;Password=;Extended properties=Excel 5.0'
)...[成绩录入$] x , BAS_BigItem u
where (x.项目 = u.f_name)
User ID=;Password=;Extended properties=Excel 5.0')...[成绩录入$]
SET 大项代码 = u.f_code
FROM OPENDATASOURCE ('MICROSOFT.JET.OLEDB.4.0',
'Data Source="D:\成绩统计.xls";
User ID=;Password=;Extended properties=Excel 5.0'
)...[成绩录入$] x , BAS_BigItem u
where (x.项目 = u.f_name)
User ID=;Password=;Extended properties=Excel 5.0')...[成绩录入$]
SET 大项代码 = u.f_code
FROM BAS_BigItem u
where (项目 = u.f_name)