Merge two tables together

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

Guest

I hope someone can shed some light on this issue for me.

I have two tables - identical in strucutre and most data. What I am trying to do is to merge the two table together so any duplicate rows (via the same rowid number) would be updated to reflect the most current information. The database wasn't replicated so I am unable to synchronize the data.

Appreciate any help.

Thanks.

Rod
 
Rod said:
I hope someone can shed some light on this issue for me.

I have two tables - identical in strucutre and most data. What I am
Click to expand...
trying to do is to merge the two table together so any duplicate rows (via
the same rowid number) would be updated to reflect the most current
information. The database wasn't replicated so I am unable to synchronize
the data.
How will you know which is 'the most current information'?

David
 
I am not sure. I was hoping that Access has some hidden time stamp when records were last updated. Otherwise, I wouldn't know which table or record was more current

I appreciate the response, but starting to think there isn't away for this to happen

Thanks for the help
 
Rod said:
I am not sure. I was hoping that Access has some hidden time stamp when
Click to expand...
records were last updated. Otherwise, I wouldn't know which table or record
was more current.
I appreciate the response, but starting to think there isn't away for this to happen.

Thanks for the help
Click to expand...

If you need to know when records were updated, you can add a [LastUpdate]
field to your table as a Date/Time field.
Add code to your form so that the Date/Time field is set to Now() whenever a
record is added or modified and - hey presto.

David
 
In hindsight that would be the smart way to go. Sadly, I inherited this mess. Best resolution is to append the two tables together and compare the data record by record. Once again I appreciate the assistance

Rod
 
I am not sure. I was hoping that Access has some hidden time stamp when records were last updated. Otherwise, I wouldn't know which table or record was more current.
Click to expand...

Your concern is well founded. Access does not keep track; if you want
this capability you must timestamp the records yourself, in a
date/time field within the record.
 
Back
Top