How To Import Records From One SQL Tbl To Another SQL Tbl In Same DB

Hello All,
I need to import records from one SQL table to another SQL table. Both tables are in the same database. Does anyone know how?

Thank you,
TinaWell, you could use DTS, or you could use an INSERT query

INSERT INTO newTable (column1, column2, column3...) SELECT column1, column2, column3... FROM oldTable

Terri|||tmorton,
I tried using DTS and got confused. I got the query to work.

Thank You!
Tina