Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / July 2007

Tip: Looking for answers? Try searching our database.

Merge two tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott - 07 Jul 2007 17:08 GMT
Recently the table has been delete some records by mistakes.  Now, I have a
backup of about one-week old table and the latest table with some deleted
records.  I would like to merge these two tables by importing the  latest
update records and new records to the old table.  Can someone give me some
guidance how to accompany this task.

Thanks,

Scott
Maurice - 07 Jul 2007 20:06 GMT
I assume the table has proper ID-keys. In that case you could use an
appendquery. All the records which are already in the table will be skipped.
Records that aren't in the table yet will be added. There are a couple of
things you need to keep in mind: Is this table not related to other tables,
because in that case you might have to update the related tables as well.
Remember before you jump into any action to make a copy of the database
before you actually are going to do some processing.

hth
Signature

Maurice Ausum

> Recently the table has been delete some records by mistakes.  Now, I have a
> backup of about one-week old table and the latest table with some deleted
[quoted text clipped - 5 lines]
>
> Scott
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.