import from one table to another

  • Thread starter Thread starter Lam
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how use dlookup to update table 3
Two tables, one form 3
Consult to Insert Data 4
Insert Values Of External Table Into Current Data Table 0
Suggestion for Append 3
How can I quickly change the table name in a query? 15
VBA - retrieve data on last create named range from previous inserted named range 0
Query from expression 2

Back
Top