software

Hi,

I had transfer a table from the server database to my local computer.
Is it possible if use excel to compare those two tables and extract the
missing records that were not copy out?

regards,
ray--
ray5_83
------------------------------------------------------------------------
ray5_83's Profile: www.excelforum.com/member.php...oamp;userid=29800
View this thread: www.excelforum.com/showthread...hreadid=495113Maybe...

Can you pick out a key field/column that is common to both?

If you can, you can use some of the techniques that Chip Pearson describes to
show the differences:
www.cpearson.com/excel/duplicat.htm

ray5_83 wrote:
gt;
gt; Hi,
gt;
gt; I had transfer a table from the server database to my local computer.
gt; Is it possible if use excel to compare those two tables and extract the
gt; missing records that were not copy out?
gt;
gt; regards,
gt; ray
gt;
gt; --
gt; ray5_83
gt; ------------------------------------------------------------------------
gt; ray5_83's Profile: www.excelforum.com/member.php...oamp;userid=29800
gt; View this thread: www.excelforum.com/showthread...hreadid=495113

--

Dave Peterson


Thanks Dave, I will take a look on it....regards,
ray--
ray5_83
------------------------------------------------------------------------
ray5_83's Profile: www.excelforum.com/member.php...oamp;userid=29800
View this thread: www.excelforum.com/showthread...hreadid=495113