Entry

How can I insert multiple rows into a database using asp?

Aug 22nd, 2001 02:47
Simon Burnett, unknown unknown, Michael Brinkley, Michiel van Otegem

It's not possible to insert more than one row at a time.

You can only insert one row at a time. Try using a loop.


Or, you could use UpdateBatch instead of Update. It batches the updates 
together and then performs them.



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

By the way - if you are inserting a lot or records try building up lots 
of INSERT commands in one SQL string then run that. One database call 
rather than an Execute command for each line.

example:

Use, 

FOR x = 1 TO 1000
  strSQL = strSQL & "INSERT INTO tblNumber (num) VALUES (" & x & ");"
NEXT
objConn.Execute strSQL

Rather than,

FOR x = 1 TO 1000
  strSQL="INSERT INTO tblNumber (num) VALUES (" & x & ");"
  objConn.execute strSQL
NEXT

It will save loads of time.