update
OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\t.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"'
)...[Sheet1$]
set brand=b.brand
from
OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\t.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"'
)...[Sheet1$] as a , [192.168.12.53].quotation_v2_1.dbo.brand as b
where a.brandid=b.brandid
[OLE/DB provider returned message: 不能更新。数据库或对象为只读。]
消息 7399，级别 16，状态 1，第 2 行
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider indicates that the user did not have the permission to perform the operation.
OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\t.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"'
)...[Sheet1$]
set brand=b.brand
from
OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\t.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"'
)...[Sheet1$] as a , [192.168.12.53].quotation_v2_1.dbo.brand as b
where a.brandid=b.brandid
[OLE/DB provider returned message: 不能更新。数据库或对象为只读。]
消息 7399，级别 16，状态 1，第 2 行
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider indicates that the user did not have the permission to perform the operation.
檢查下看看