优化代码:Sub Updata 设置数据库连接 Dim conn As Object Set conn = CreateObjectADODBConnection connOpen Provider=MicrosoftACEOLEDB120;Data Source=E检测设备力学VBA测试Newmdb 设置SQL语句 Dim strSQL As String
Sub Updata() ' 设置数据库连接 Dim conn As Object Set conn = CreateObject("ADODB.Connection") conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\检测设备\力学\VBA测试\New.mdb"
' 设置SQL语句
Dim strSQL As String
strSQL = "UPDATE ReportParam SET TestPreceptName='抗压试验GBXXX', Title='XX抗压强度检测记录' WHERE ID1=1;"
' 执行SQL语句
conn.Execute strSQL
' 关闭数据库连接
conn.Close
End Sub
原文地址: https://www.cveoy.top/t/topic/fEOu 著作权归作者所有。请勿转载和采集!