how to copy data from one table to another table in Access

Question

i need to data from one table to another table in Access,i Have table1 with 10rows i need to copy only ProductId,ProductCat to Table2 with ProductId,ProductCat

Answer 1

Luckily the names for the columns are optional so you can also let Access copy every column without naming them explicitly:

insert into [TargetTable] select [SourceTable].* from [SourceTable];

INSERT INTO statement (Microsoft Access SQL)

Answer 2

You can do SQL

this is off the top of my head, so hopefully it works!

INSERT INTO Table2 (ProductId, ProductCat) SELECT Table1.ID, Table1.Field1 FROM Table1;