sql - Insert Data from one table to another in the Same Database due to import wizard -

firstly new programming , sql (7 months) , first time have done this. self taught part.

here goes,

i have excel spreadsheet data in it, column names correspond names in database. used wizard , managed import data. rather insert data target tables wanted stupid thing (which doesn't let amend destination btw) created new tables (exactly same tables had created except $ @ end) , inserted there!

i've tried few things , best , close can question

how hell transfer records created tables need them?

we talking 4 tables (in 7 table db) , hundreds of inserts in 2 of tables , on 2,000 in other two.

the proper tables

dbo.crystal dbo.essential dbo.mineop dbo.origin 

the falsely created tables dbo.crystal$ dbo.essential$ dbo.mineop$ dbo.origin$

all columns , values etc same in fact identical copies of each other need $ ones original ones (that have keys , constraints) , ill delete false tables.

can these in bulk?? if please give me exact script syntax need this, have no idea. know basic commands , insert statements, don't know let alone how join or merge/r is? let alone how

i using microsoft sql server management studio 2012 (express)

insert [jdatabase].[dbo].[mineop] (name) select name [jdatabase].[dbo].[mineop$]; 

and same other tables other table details! negative vote!