Asp,mdb, tools

<%
Set Conn=server.createobject ("ADODB. Connection ")
Conn. Provider= "Microsoft.Jet.OLEDB.4.0"
Conn. Open "/test.mdb"

Set rs = Server.CreateObject ("Adodb.recordset")
Rs. Open "SELECT * FROM class", Conn

Do Until Rs. Eof
For each x in Rs. Fields
Response.Write (X.name)
Response.Write ("=")
Response.Write (X.value & "<br/>")
Next
Response.Write ("<br/>")
Rs. MoveNext
Loop

Rs.close
Conn.close
%>

Pay attention to Conn. Open "/test.mdb"//test.mdb location

The. MDB tool, if you do not want to install Office, can download Mdbplus (password:5b5q)

Asp,mdb, tools