Combine two Access files of the together in one

A

atlskw

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
 
J

Jeff Boyce

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).
 
Top