Prev < Pivot tables            Next > Export and import data

Enhanced Copy and Paste

You can Copy and Paste multiple rows between tables or within single table:

Copy multiple rows

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

Error on paste

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

Fixing paste

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

Excel copy

Prev < Pivot tables            Next > Export and import data