adodc1 multi row at the time .

hi all
this is my first thread in this VB forums :),

now i using adodc connection with ODBC mysql database .
how i can make the adodc read multi row at the time , not single row at the time, to speed up the process , ?
example of my work

Code:

---

for i = 0 to adodc1.recoredset.recoredcount
adodc2.addnew
adodc2.recoredset.fields(0) = adodc1.recoredset.fields(0)
adodc2.recoredset.fields(1) = adodc1.recoredset.fields(1)
adodc2.update
next i

---

please help me with any advice that will may speed my process ..
regards

Why did y take two Adodc control at the form ?.what do y want to achieve ?.:)

hi

thank you for replay

because we need to copy table from database 1 to other database 2

and the system process one row at the time which is slowly and i want to speed up by take multi rows .