Hi,

This question may look stupid.
If i'm not wrong, ADO is faster than DAO,But can anyone explain to me that why when i work with ADO it looks slowly than DAO.
selecting or compling sql statement also very slow.

'ADO code when select
select firstname,lastname,address,mobile from tbl1

'DAO code when selct
set rs=db.openrecordset("tbl1",dbopendynaset)

'ADO code when using sql statement
do while not rs.eof
sql="insert into tbl1 (firstname) values(" & rs.fields!firstname & "')"
loop

'DAO code when using sql statement
rs.addnew
rs.fields!firstname=rs2.fields!firstname
rs.update

'there is >200K records

if i explain not clearly please ask me for more info

thanks