Hi ,
I have  added the quotes as you suggested, I havent set a primary key on the second table (dbo.MVF_Transport_Acc) this would be the reason why it is inserting duplicate records, I will try this
thanks for your reply