添加了一个模块
Public cn As New ADODB.Connection '连接
Public rs As New ADODB.Recordset '记录集
Public Sub OpenConn() '连接数据库
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "driver={SQL Server};server=zhangd;uid=sa;pwd=;database=学生成绩管理"
End Sub