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