DataGrid help please

I want to copy lots of rows of data in a table in Excel into a DataGrid in VB.Net.

Currently, i am able to select all the data in the datagrid in vb.net and delete it.

However, when i copy the data in Excel and try to paste it into the datagrid, it only pastes the first row.

Is there a property i can change, or a piece of code i can enter which will solve this problem?

Matt

actually, i just realised that it is copying all 820 rows into the first cell.

so what should i do?

hmmm...so no one knows?

this is a real bugger...