Mission Impossible - Comparing Files

From: lalexander (l_alexander_at_verizon.net)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 15:30:28 -0400

I've been given the project of comparing a current Excel Spread*** against
a historical Spread***.

They both have the same Employee ID.( Or new ones added on the Current
File )

My task is ( should I chose to accept - Mission Impossible )

Is to determine the following:

                    * How many new records are added on the Current File
                    * Identify any changes that occur on the either file

This could possibly involves creating something called a - Changed File.

I've used a program called ExelDiff, but it failed miserably , when the
information being compared wasn't in the same position.
So I have turned to Access ( because of the unique employee ID )

This project was supposed to go live today - 10/7/04 using ExcelDiff ( but
somehow I don't think this is going to happen )

Any help outling my immediate course of action would be very much
appreciated.

Could someone in the Access Community Please help.

Loading