Batch data insert

I 开发者_运维问答need to fetch data from one table (multiple rows) and insert into other table after modifying and adding some new fields.

For example:

Table 1 itemid, price, qnt, date_of_dispatch

Table2 Invoiceid, Invoicedate, customer_id, itemid, price, qnt, total_amt, date_of_dispatch, grandtotal

Please help me to make it in asp with ms access

You need to add all the input type with the same name, so you can collect an array with all the values.

Sample:

<form ...>
   <input type="text" name="InvoiceDate" ..>

   <table>
   <thead>
         ....
   <thead>
   <tbody>
   <% do while not rsItems.EOF %>
    <tr>
       <input type="hidden" name="ItemID" value="<%= trim( rsItems("itemID") ) %>">
       <td><input type="text" name="Product" value="<%= rsItems("Product") %>"></td>
       <td><input type="text" name="Price" value="<%= rsItems("Price") %>"></td>
       <td><input type="text" name="Qnt" value="<%= rsItems("qnt")%>"></td>
    </tr>
    <% rs.movenext %>
   <% loop %>

Then, when processing the form:

for i = 1 to request.form("ItemID").count
   ThisItemProduct = request.form("Product")(i)
   ThisItemPrice = request.form("Price")(i)
   ...

You can work the details.