title: Insert Data from one table to another in the Same Database due to import wizard
body: <p>firstly i am new to Programming and SQL (7 Months) and this is the first time i have done this. i am self taught for the most part.</p>
  
  <p>here it goes,</p>
  
  <p>I have an Excel spreadsheet with all the data in it, all the column names correspond with the 
  names in the database. i used the wizard and successfully managed to import the data.
  HOWEVER rather than insert the data into the target tables as i wanted the stupid thing (which doesn't let you amend the destination btw) created new tables (exactly the same as the tables i had created except with a $ at the end) and inserted everything there!</p>
  
  <p>I've tried a few things and this is the best and as close as I can get so my question is </p>
  
  <p>How the hell do I now transfer ALL the records from the created tables into where I need them?</p>
  
  <p>we are talking about 4 tables (in a 7 table DB) and hundreds of inserts in two of the tables and over 2,000 in the other two.</p>
  
  <p>the proper tables are </p>
  
  <pre><code>dbo.Crystal
  dbo.Essential
  dbo.MineOp
  dbo.Origin
  </code></pre>
  
  <p>the falsely created tables are 
      dbo.Crystal$
      dbo.Essential$
      dbo.MineOp$
      dbo.Origin$</p>
  
  <p>all the columns and values etc are the same they are in fact identical copies of each other
  but i need the $ ones into the original ones (that have keys and constraints) and then ill delete the false tables.</p>
  
  <p>Can I do these in Bulk?? if so someone PLEASE give me the EXACT Script syntax i need to do this, as i have no idea. i know my basic commands and insert statements, don't know what let alone how a JOIN or MERGE/R is? let alone how to do it </p>
  
  <p>I am using Microsoft SQL Server Management Studio 2012 (Express)</p>