Set Conn = CreateObject("adodb.connection")
'定义连接的SERVER名,数据库名,用户名和密码
Conn.Open "Driver=SQL Server;SERVER=DB001;Database=DBtest;uid=userID;pwd=password"
'判断连接状态
If Conn.State = 1 Then
'定义SQL文
sqll = "SELECT * FROM table1"
'将结果显示到a2单元格
[a2].CopyFromRecordset Conn.Execute(sqll)
&n