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: