How do I move table contents to another table?

Databases
1

I want to move table contents from one table to another, Is there any easier way of doing it other than the long winded way of exporting, renaming then importing as another table?:confused:

2 
INSERT
  INTO targettable
     ( [I]column
     , column[/I] )
SELECT [I]column
     , column[/I]
  FROM sourcetable

optional WHERE clause if desired, etc.