Prev < Pivot tables Next > Export and import data
You can Copy and Paste multiple rows between tables or within single table:

However, pasting multiple rows usualy fails because of table constraints - you're trying to insert another row with same primary key:

With DbOctopus you can just fix problematic fields which broke table contraints, and finish paste succesfully:

Copy and paste is compatible with Excel, so you can directly copy to/from Excel tables:
