Combining Tables

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

Guest

Hi all,
Is there an easy way to create a query or VBA of some sort that will combine
two tables (t1 & t2) that are identical in structure, but different in data,
so that all duplicates in T1 will be overwritten by data coming from t2 and
all final data displayed now in t1? Or pass the data from t1 to t2, but any
duplicated data coming from t1 will not overwrite the data in t2?
Any help would be greatly appreciated! Thanks!
-gary
 
Gary

?How is this a forms question?

Take a look at Access HELP on "update queries". If I'm understanding your
situation, you want to update the records in one table based on the
(related) records in another.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff, sorry about the delay in my response. I was creating a merging
tool on a form and usually had luck creating a query first, and then
converting to SQL but got stumped with this one. After reading your
response, it became pretty clear that if all I needed to do was run a simple
append query and be sure that I was moving the "old" table over to the "new"
table, that way, anything that exists in the "new" table would not be
overwritten by the "old" table data. Sorry again for posting this in the
wrong area, but appreciate you taking the time to respond. Thanks
-gary
 
Back
Top