How to import table using “INSERT” statement?

I have made a new temporary color table which is flourished using the below SQL. Structures of both the table should be same in order that this SQL executes properly.

INSERT INTO TempColorTable

SELECT code,ColorValue

FROM ColorTable