Help! Whatever books or sites I visit, I cannot get an answer for how to copy data from table to table in Access.

Could someone please tell me how I can get all the data from field1 in table 1 in Access97 into field1 in table2 ?

I have tried loops, addnew, clone, probably every function apart from the right way of going about it and have run out of options.

ANY help would be VERY appriciated.

Thank you everyone !

alex read
[email protected]