Insert multiple rows as an array....

Hi all,

I want to insert multiple data in once....

Example: That's how my code works now...

"cnn.execute" executes this code each time inside loop and then I'm taking datas from another table and writing my table....

do while not RS.Eof

sqlstr2="insert into T_NBS_CCM_LIST(CTI,NAME,CLUSTERID) values('" & rs("ctiID") & "','" & rs("name") & "','" & rs("cID") & "')"

cnn.execute(sqlstr2)
rs.MoveNext
loop

what i want to do is something like below....

do while not RS.Eof

array1= array1 + "," + rs("ctiID")
array2= array2 + "," + rs("name")
array3= array3 + "," + rs("cID")

rs.MoveNext
loop

sqlstr2="insert into T_NBS_CCM_LIST(CTI,NAME,CLUSTERID) values('" & array1 & "','" & array2 & "','" & array3 & "')"

cnn.execute(sqlstr2)

The select statement below but I want to use it as insert statement....

here "extension " and "user" variables are array...

Select * from T_NBS_INTERNAL WHERE (EXTENSION IN (" &extension&") OR USER_CODE IN (" &user&"))"

So what i'm lookin for is something like

Insert into T_NBS_INTERNAL values (EXTENSION IN (" &extension&") OR USER_CODE IN (" &user&"))"

Thanx in advance....

--
Posted via http://dbforums.com