Pasting Entire Collections into a Grid from a Spreadsheet

The procedure to copy an entire collection of records from a spreadsheet and paste them into a grid is virtually the same as the procedure described for a subset of records .

The only real difference is that you select the entire collection instead of just a subset of rows.