View Single Post
  #2 (permalink)  
Old March 25th, 2004, 09:06 PM
Steven Steven is offline
Friend of Wrox
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

How's this sound?
INSERT INTO Table2( Field1, Field2, FieldN )
SELECT Field1, Field2, FieldN
FROM Table2;
Which you could also do using the GUI with an Append query.

I am a loud man with a very large hat. This means I am in charge