Combine two Access files of the together in one

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

Guest

aIhave a web site with the database file that I download and update. I need
to combine all the customers data before I upload a new one becuase the files
are the same it over writes the old data.
I want to combine my Data from ex. Shop.mdb (Todays file) with Shop.mdb
(Yesterdays file) etc. I am not very experienced in this and want to learn or
pay someone to make this easy for me to do.
Thanks
 
From your description, it sounds like you have exact duplicates (except for
the dates). Would it be any easier to just add a Date/Time field in your
table(s)? That way, you might not need to combine and overwrite...

Or maybe you are describing a situation in which replication would be
appropriate. Have you looked into this approach? (there's a newsgroup
dedicated to replication, too).
 
Back
Top