假设access文件名:mybook.mdb,放在data目录下,里面有个book的表,含有id,name字段
用asp读取所有name内容,并按id顺序降序排列,代码如下:
<%
dim conn,connstr,rs,sql
db="data/mybook.mdb" '数据库名称,建议修改成.asp后缀
set conn=server.createobject("adodb.connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;data Source="&Server.MapPath(db)
conn.open connstr
set rs=server.CreateObject("adodb.recordset")
sql="select * from book order by id desc"
rs.Open sql,conn,1,1
while not rs.eof
response.write rs("name")
rs.movenext
wend
rs.close
%>
===================================================
so自助链-中国最专业自助友情链接交换平台-无需审核-快速交换链接_so444.com