Paste cells into datagridview

Question

I have a datagridview and I need for users to be able to paste cells into it form excel (and maybe sql server management studio but not as important) does any one know how I would go about this

Many thanks

Alec