在此之前你必须引用Microsoft ADO libriry
dim conn as adodb.connection
dim rs as adodb.recordset
set conn=new adodb.connection
set rs=new adodb.recordset
conn.open"......(其实这段可以先用控件弄出来的,直接复制粘贴就行了,我试过了很管用的)"
rs.open"(SQL语句中变量是'"&text1.text&"')",conn,.....(一串,有提示的)
哎呀差不多了就这样咯
Private connstr As String
Private cn As ADODB.Connection
Private rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Provider = "Microsoft.Jet.OLEDB.4.0"
connstr = "Data Source=c:\master.mdb"
cn.ConnectionString = connstr
If cn.State = adStateOpen Then
cn.Close
Else
cn.Open
End If
sql = "create table s(s char(5),sn char(8))"
Set rs = New ADODB.Recordset
Set rs.ActiveConnection = cn
If rs.State = adStateOpen Then
rs.Close
End If
rs.Open sql, cn, adOpenKeyset, adLockPessimistic