import from one table to another

L

Lam

HI
I have some tables in one MDB files
I need to import some data from one table to another one,
eg, insert all table1.name to table2.name
how can I do that in Access?

Thanks a lot
 
R

Rick B

Are there fields in each table to allow you to know which table1.name goes
into which record in table2? What type of data is in each table?

If so, why would you want to put the data in both tables? That is
redundant. Just relate the two tables to each other. If a name is spelled
wrong or changes, you don't want to have to fix it in two places.

A 'relational' database should store information only once and then can be
related to other records in other tables.

If I misunderstand your design/purpose, please post back.
 
Top