Public db As Database
Public conn As ADODB.Connection
Public rs As ADODB.Recordset
Set conn = CreateObject("ADODB.Connection")
conn.Open "DSN=CZ1;UID=;PWD="
Set rs = CreateObject("ADODB.Recordset")
rs.Open "RC"
我知道用ODBC,我是这样写的:
Public db As Database
Public conn As ADODB.Connection
Public rs As ADODB.Recordset
Set conn = CreateObject("ADODB.Connection")
conn.Open "DSN=CZ1;UID=;PWD="
Set rs = CreateObject("ADODB.Recordset")
rs.Open "RC"
其中RC为表名这样可不可以,CZ1是我建的数据源.
但是老是出错.
我是在VBA里用的!