Copying data of certain fields, to the same fields of another table

[AshikHusein]

I have a basic question for copying particular fields in a table to another table.

Say I have a table called "Table1" with fields

aaa, bbb, ccc, ddd, eee, fff

Now if I have another table, say "Table2", which has fields aaa, bbb, ccc and I want to copy all data from Table2 to Table 1, how would I do this?

Please note that I dont want to append the data but copy the data, which means that the data of fields aaa, bbb, and ccc of Table1 will be completely overwritten by the same fields of Table2.

would appreciate an insight into the matter. Thanks.

Ashik

 

[llkhoutx]

An update query would be easiest. However, you could also use DAO code.

 

[AshikHusein]

Thanks for the help.