Lynn

I just downloaded this sample code from a website and amended accordingly and your right I do not want to update data that already exists so thanks for pointing that out to me.

Finally yes as you say all I want to do is

insert data that does not already exist in the Target Table and ignore the data that does

thanks