Comment 2 for bug 460768

I just ran into this error message. In my case, I got it working by adding the name of the database plus a period to the new table's name. So, if you want a table named "Table1" in database "thedb", just make sure the "Table name" is set to "thedb.Table1" in the data-pasting wizard. Hope that helps!

If others see this same behavior, I think it may be a usability bug. When right-clicking an existing table in the "Tables" panel to paste data, it usefully gives "exampledb.existingtable" (modified appropriately) as the table name, so you can append data to the table using the wizard. If you right-click on a database in the same panel, however, it just gives "Table1" (or something similar) as the table name, assigning it to no database; not even the one you right-clicked, which seems to lead to this mostly-unhelpful error.

There's one fix I can think of that should be fairly easy for any devs getting this message: use "exampledb.Table1" as the default name, with "exampledb" replaced by the right-clicked database's name, if it's not too much trouble. More ambitiously, one could change the wizard to have the database and table names as separate entries, possibly with the database being uneditable.