|
excel 2010 update 不能更新 excel 数据
代码如下,详情请参附件,谢谢!
之前试过2003是可以的。
Sub 根据另一个工作簿更新数据update2010()
Dim cnn As Object
Dim sql As String
Dim p As String, f As String
p = ThisWorkbook.Path & "\"
f = Dir(p & "B.xlsx")
Set cnn = CreateObject("adodb.connection")
cnn.Open "Provider=Microsoft.ace.OLEDB.12.0;Extended Properties=Excel 12.0 macro;Data Source=" & ThisWorkbook.FullName
sql = "update [Excel 12.0;Database=" & p & f & "].[Sheet1$] a,[Sheet$] b set a.DES=b.DES where a.awb=b.awb"
cnn.Execute sql
cnn.Close
Set cnn = Nothing
End Sub
|
|