You'll have the least amount of problems using DTS import/export wizard. Select the source server/database and the destination server/database and choose to Copy Objects and Database between SQL Server databases.

Check all uncheck "create destination objects..." depending on your circumstances. If creating new objects at the target, I recommend including dependent objects too.

Obviously choose to copy data but, again, replace or append depends on your circumstances.

Uncheck "Copy all objects" and in the Select Objects dialog, just choose the tables you want.

Uncheck "Use default options", then in the Advanced Copy Options dialog uncheck "Copy database users and database roles" but leave all the others as is.