ASP连接 connectionString

连接MSSQL SERVER

set conn=server.CreateObject("adodb.connection")
conn.provider="sqloleDB"
conn.connectionSTring="server=127.0.0.1,1433;database=DB;uid=sa;pwd=123456;"
conn.open

注意有端口

 

连接Excel

Set conn=Server.CreateObject("ADODB.Connection")
StrConn="Driver={Microsoft Excel Driver (*.xls)};DBQ="& Server.MapPath("2.xls")
conn.Open StrConn

Sql="select * from [Sheet1$] where 日期 like '2013'" (字段名就是第一行各列名)