dim cn as new connection
cn.open "Provider=Ms Remote;Remote server =http://www.my.com;Remote Provider=MSDASQLl;Dsn=Pubs"
dim re as new recordset
re.cursorlocation=aduseclient
re.open tablename,cn,adopenstatic,adlockbatchoptimistic,adcmdtable
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=YourUserName;Password=YourPassword;Initial Catalog=远程数据库名;Data Source=远程服务器的IP地址(如172.00.00.000)"