Thanks Ben,

i guess for the time being i will stick with access before experiemnting with other products.

Thank you for your contribution

C

Thanks Ben,

I am using SSIS, i can use vbcrlf cmd in access but we are trying to move away from that.

thanks,

Chris

Thanks for you response, this will work for my initial question. Unfortunatly i have about 70 columns, is there a short way of doinf this without clobbering the sql codes...