suspected easy answer - newbie!

[alex_read]

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
alex.read@avnet.com

[lenin]

Hi,
this should work:

insert into table1(name_new)
select name from customer


this inserts everything from column name in customer table to name_new in table1

I have just tested it and it is fine

HTH.

Lenin