Select in to

[Kishor]

Hi,

In Aceess 2002, Is there any way to insert multiple records resulted from a
query in to another table using a query (Select in to). I don't want to
delete data in other table.

Tia,

Kishor

 

[Van T. Dinh]

(newsgroups trimmed. Please restrict to a max of 3 relevant newsgroups).

Check Access / JET SQL Help on the INSERT INTO statement.

 

[Duane Hookom]

You can use an Append Query. Check Help and if you have questions, come on
back.