update EmployeeSalary set cust2006= execl.Salary
from
OpenRowSet('microsoft.jet.oledb.4.0',
'Excel 8.0;database=F:\SALARY.XLS;',
'select * from [Results$]') as execl,EmployeeSalary s
where s.employeeid=( select employ.EmployeeId from employees employ where employ.number=execl.number)用EXECL中的数据去更新数据库中表的数据;更新条件是编号;这语句运行 很慢;
from
OpenRowSet('microsoft.jet.oledb.4.0',
'Excel 8.0;database=F:\SALARY.XLS;',
'select * from [Results$]') as execl,EmployeeSalary s
where s.employeeid=( select employ.EmployeeId from employees employ where employ.number=execl.number)用EXECL中的数据去更新数据库中表的数据;更新条件是编号;这语句运行 很慢;
EXecl另有employeeid,consume,paylater想将EXECL中的consume,paylater中的数据来更新表的数据通过employeeid来连接;