first set your database. then when adding just use RecordsetName.AddNew
RecordsetName("Name of Fields") = "content"
RecordsetName.Update
Here is an example.
<%
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& _
Server.MapPath("database.db")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open strConnect
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.open "test",objConn,2,2
objRS.AddNew
objRS("name") = "Jake Doe"
objRS("age") = "101"
objRS("phone") = "215-000-0000"
objRS.Update
objRS.close
objConn.close
%>
|