7,713
社区成员
发帖
与我相关
我的任务
分享
dim cnn As ADODB.Connection '连接数据库的Connection对象
dim rs As ADODB.Recordset '保存结果集的Recordset对象
dim ConnectionString as string
ConnectionString = "Provider=SQLOLEDB;Data Source=" & ServerName & ";Initial Catalog=" & & ";User ID=" & & ";Password=" & & ";" '设置连接字符串ConnectionString属性
Set cnn = New ADODB.Connection
'设置连接字符串ConnectionString属性
cnn.ConnectionString = ConnectionString
rs.open "select * from biao"
DO while not rs.eof
//操作
loop