How do I move records from one table to another with different fi.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables with common and unique field names. I need to move the
common data between the two tables and keep the unique data. I can do this
manually of course but how can I let Acess do it for me?
 
In a well-normalized relational database, there's rarely a need to have
duplicate data in two tables. If you describe a bit more about why you feel
it's necessary to "move data between tables", the 'group may be able to
offer alternative approaches.

It's absolutely possible to do, I'm just asking to see if it is also a good
idea to do...
 
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

Excel Moving data to sheet2 from sheet1 0
how do I add data from one table to another table? 4
how to combine two tables into one table 2
Reports that sift records from different tables 0
Update Two Tables Using One Form Contents 0
VBA - retrieve data on last create named range from previous inserted named range 0
acnewrec? 1
Relating fields to other fields 3

Back
Top