SQL Script !!

ciko1973 · June 13th, 2003, 06:57 AM

Hi, friends,
as can I do to add data in a table from another table?
Warning! I have already a new table and must only copy a data from another table..:)

Thank you !!!

Steven · June 13th, 2003, 07:03 AM

Yes - with an "append query"

You can either write the SQL Insert statement yourself
such as

Code:

INSERT INTO Table1 (Field1, Field2)
SELECT Field1,Field2
FROM Table2;

- or you can get Access to do it for you, by selecting "APPEND" in the query type.

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends

ciko1973 · June 13th, 2003, 07:10 AM

Thank you!!!!1
I made the error to make too many parentheses...:D