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

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

Back
Top