Thankyou to all who replied to my post.

Have tested the bcp option and works like a charm

Thanks again

Deb

Thanks for you reply, but I want to be able to do it using a stored procedure so that it can be called from cold fusion.

Regards

Deb