Insert Rows from One Table To another

[Squik27]

I have two tables and one of them is a temp_table
Is there a way to insert certain rows from the original table to the
temp_table without using SELECT INTO statement?

the problem with select into is that I have to guarantee that temptable
doesn't exist; if I try to DROP temptable I have to guarantee that it exists
and also SELECT INTO won't give default values.

I already did this in two steps.
I openrecordset with the original table and looped through it to copy its
values into the temptable. I'd like to do it in one swap.

thank you

 

[UpRider]

INSERT INTO temptable SELECT * FROM originaltable WHERE .....

HTH, UpRider.

 

[Tom van Stiphout]

On Tue, 9 Jun 2009 16:49:01 -0700, Squik27

Sure. You can use an Append query, which uses the INSERT INTO
statement.

-Tom.
Microsoft Access MVP