RE: Mission Impossible - Comparing Files

From: George (George_at_discussions.microsoft.com)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 13:05:01 -0700

lalexander,
I had a similar mission in Access at my last position. There is a product
out on the market called "Total Access Detective" by FMS (I believe...if not,
a quick search on the internet will get the correct distributor). It has a
cost of about $200, but it also has a return guarantee if it does not suit
your needs. I was able to use this product with relative ease showing which
records were added, deleted, and (if changed) detailing all changes. Good
luck

"lalexander" wrote:

> 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