In the ASP page, assemble your data into variables (normally one variable for each column to be inserted). The data should be delimitted with a "|", comma, etc. Then do all the looping in ONE stored procedure. On each loop, parse your next set of data to insert. The ASP page should call the stored procedure ONCE. This is faster and easier on system resources.
If you're stuck on were to start then first create the stored procedure to insert one round of data. Get that working correctly. Then upgrade the stored procedure's variables to hold delimitted data. Get that working. THEN go to your ASP file and work on assembling the data.
