Copy from one table to the other

A

AccessLover

I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I
want to copy all values in Fld3 to Fld1. How can I do it
 
C

Carl Rapson

AccessLover said:
I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I
want to copy all values in Fld3 to Fld1. How can I do it
Click to expand...

INSERT INTO Tbl1 (Fld1) SELECT Fld3 FROM Tbl2;

Carl Rapson
 
C

Carl Rapson

Create a new query based on Tbl2. Select Append Query and specify Tbl1 as
the table to append to. Under Field, select Fld3 (Table should be Tbl2).
Under Append To, select Fld1. Then run your query.

Carl Rapson
 
Top