我也比较喜欢用adodb连接数据库
在校就做项目,很好啊!努力肯定会有收获!下面是我连接数据库的常用方法,希望对你有所帮助!
Dim Con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strCon As String, strSQL As String
Set Con = New ADODB.Connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\sf.mdb"
Con.Open strCon
Set rs = New ADODB.Recordset
strSQL = "select sum(YGRC) as total from [sf] where format(RQ,'yyyy-mm')='" & Left$(Date$, 7) & "'"
Set rs.ActiveConnection = Con
rs.Open (strSQL)
Text10.Text = rs("total")
rs.Close
Set rs = Nothing