<!DOCTYPE html>
<html>
<body>

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn

第一個數字表示要複製的記錄數
第二個數字表示從哪條記錄開始
p=rs.GetRows(2,0)

response.write("此示例返回前兩條記錄的第一列的值：")
response.write(p(0,0))
response.write(" ")
response.write(p(0,1))

response.write("此示例返回第一條記錄的前三列的值：")
response.write(p(0,0))
response.write(" ")
response.write(p(1,0))
response.write(" ")
response.write(p(2,0))

rs.close
conn.close
%>

</body>
</html>