db="article.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="rovider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
再使用
set rs=server.createobject("adodb.recordset")
strSQL="select top 20 * from ls_djb_v order by datdjsj desc"
rs.open strSQL,conn,1,1
连接指定的表