Results 1 to 3 of 3
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Exclamation Merging Data from two databases


    I am looking for a way to be able to merge information between two databases that house the same information. I have the scenario set up below.

    A co-worker came to me for a database that they work with for Grants for the company. They normally use the original database file to make changes. A separate coworker added information into the _Backup database instead of the original database. Now there is information in both databases to where the number of records do not match in each database. On that same note, a certain student may be in both copies with a different amount of classroom hours. What is the best way to try to merge this information?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Very carefully.

    How much data went into the backup? Easiest is to do the same data entry in the correct db. Otherwise, set links to tables in the backup and run queries that compare records. Then do manual edits or run INSERT or UPDATE SQL actions as appropriate.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    Thanks a bunch for the information! Always can count on you June!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 10-20-2014, 05:43 PM
  2. Merging Two Databases with over 200 tables
    By Msaccessuser in forum Access
    Replies: 6
    Last Post: 09-25-2012, 08:13 PM
  3. Merging two identicle Databases
    By thclegg in forum Access
    Replies: 1
    Last Post: 09-06-2012, 03:23 PM
  4. Merging data
    By jaZZerkill in forum Access
    Replies: 1
    Last Post: 04-09-2012, 08:43 AM
  5. Replies: 1
    Last Post: 04-28-2011, 07:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums