BrettM just a pert, "ex" to come Local time Tomorrow, 05:31 Joined Apr 30, 2008 Messages 134 May 10, 2009 #1 What is the simplest way to compare two external databases that hold table data only? Any suggestions would be appreciated. Regards Brett
What is the simplest way to compare two external databases that hold table data only? Any suggestions would be appreciated. Regards Brett
RainLover VIP From a land downunder Local time Tomorrow, 05:31 Joined Jan 5, 2009 Messages 5,031 May 10, 2009 #2 In one of the databases create a link to the tables in the other database. Then use the New Query Wizard "Find Unmatched Query Wizard" I assume by compare you are wanting to compare the data.
In one of the databases create a link to the tables in the other database. Then use the New Query Wizard "Find Unmatched Query Wizard" I assume by compare you are wanting to compare the data.
W WayneRyan AWF VIP Local time Today, 18:31 Joined Nov 19, 2002 Messages 7,120 May 10, 2009 #3 Brett, Maybe this will help somewhat. http://www.access-programmers.co.uk/forums/showthread.php?t=127628 Wayne
Brett, Maybe this will help somewhat. http://www.access-programmers.co.uk/forums/showthread.php?t=127628 Wayne