I am trying to add multiple records to the same table in my database. I know how to enter one recordset to my database at a time, but how do I enter multiple recordsets to the same db table. Here is what i have so far. Can anyone tell me what I am doing wrong? 

------------------------

test.asp

------------------------

<form name = "form" form method="POST" action="test2.asp">
  <p><input type="text" name="varname" size="20"><input type="text" name="varid" size="20"></p>
  <p><input type="text" name="date1" size="20"><input type="text" name="value1" size="20"><input type="text" name="notes1" size="20"></p>
  <p><input type="text" name="date2" size="20"><input type="text" name="value2" size="20"><input type="text" name="notes2" size="20"></p>
  <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

---------------------------

test2.asp

---------------------------

DIM adoCon, mySQL

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Provider="Microsoft.Jet.OLEDB.4.0"
adoCon.Open "c:\inetpub\wwwroot\cworkman\testing\GAFKPM.mdb"

FOR i = 1 to 2

IF Request.Form(" Value" & i) > " " THEN

mySQL = " INSERT INTO Val (varid, date, value, notes) VALUES"
mySQL = mySQL & " (#" & Request.Form(" varid" ) & " #, #" & Request.Form(" date" & i) & " #, #" & Request.Form(" value" & i) & " #, #" & Request.Form(" notes" & i) & " #)"
Response.write(mySQL)
adoCon.execute(mySQL)

END IF

NEXT

adoCon.close
set adoCon=nothing

I have figured it out but now I am getting a type mismatch error. I have noted it below. Can you help me?

madd.asp

---------------------

<%
vid=Request.Form("varid")
vname=Request.Form("varname")
%>
<!-- Begin form code -->
<center>

<form name="form" form method="POST" action="maddd.asp">
  <div align="center">
    <center>
    <table border="1" cellpadding="0" cellspacing="0" width="586">
      <tr>
        <td width="312" colspan="2">Variable:<input type="text" name="varname" maxlength="50"></td>
        <td width="268">Variable ID:<input type="text" name="varid" maxlength="50"></td>
      </tr>
      <tr>
        <td width="162" align="left"><b>Date: </b></td>
        <td width="148" align="left"><b>Value:</b></td>
        <td width="268" align="left"><b>Notes:</b></td>
      </tr>
      <tr>
        <font size="1">
        <td width="162"><select size="1" name="month1" style="font-size: 8pt">
        <option value="1/">1</option>
     <option value="2/">2</option>
     <option value="3/">3</option>     
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
 <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
     <option value="12/">12</option>
          </select>
          <select size="1" name="day1" style="font-size: 8pt">
 <option value="1/">1</option>
 <option value="2/">2</option>
     <option value="3/">3</option>
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
  <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
     <option value="12/">12</option>
     <option value="13/">13</option>
     <option value="14/">14</option>
 <option value="15/">15</option>
     <option value="16/">16</option>
 <option value="17/">17</option>
     <option value="18/">18</option>
 <option value="19/">19</option>
     <option value="20/">20</option>
 <option value="21/">21</option>
     <option value="22/">22</option>
     <option value="23/">23</option>
     <option value="24/">24</option>
 <option value="25/">25</option>
     <option value="26/">26</option>
 <option value="27/">27</option>
     <option value="28/">28</option>
 <option value="29/">29</option>
     <option value="30/">30</option>
 <option value="31/">31</option>
          </select>
          <select size="1" name="year1" style="font-size: 8pt">
 <option value="2003">2003</option>
     <option value="2002">2002</option>
 <option value="2001">2001</option>
     <option value="2000">2000</option>
     <option value="1999">1999</option>
     <option value="1998">1998</option>
        <option value="1997">1997</option>
        <option value="2004">2004</option>
        <option value="2005">2005</option>
          </select>
          </font>
        <td width="148"><input type="text" name="value1" size="20"></td>
        <td width="268">
        <textarea rows="1" name="notes1" cols="31" maxlength="50"></textarea>    & nbsp;    
        </td>
      </tr>
      <tr>
        <font size="1">
        <td width="162"><select size="1" name="month2" style="font-size: 8pt">
        <option value="1/">1</option>
     <option value="2/">2</option>
     <option value="3/">3</option>     
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
 <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
     <option value="12/">12</option>
          </select>
          <select size="1" name="day2" style="font-size: 8pt">
 <option value="1/">1</option>
 <option value="2/">2</option>
     <option value="3/">3</option>
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
  <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
&n