如果在查询分析器中删除excel里的数据?
我用如下语句删除excel里的文件时提示如下错误信息,
Server: Msg 7345, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' could not delete from table 'mydata'. There was a recoverable, provider-specific error, such as an RPC failure.请高手帮忙!我用的是7.0
DELETE
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="e:\lx\lx1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...mydata