Here inserted records are into queryB....
i need total no of records that are inserted into my sourceDB

i need one clarification in above....
why did u mentioned rst.Recordset=0 in if statement....
I don'think,if statement works here....
plz suggest me...