@kishen1912: please follow Pike's instructions or you will not get any assistance.

A suitable titke might be "Data mismatch in ADODB Connection"

Also note that, although you have provided more code, there is nothing to test it with. Please post a workbook.

I, for one, will not try to generate test data in order to find a fault in your code.

Regards