How to copy data from one DB to another through ADO

[jsmith]

I need to copy data from one DB to another using ADO. I need to see if the data exist then do update and if not insert it.

Any ideas on a code ?
thanx a lot