Hi All:

I have been asked to produce a file with 300,000 records for viewing in SharePoint (of which I know little).

Thereafter, instead of rerunning the generation of the file, the SP programmer wants me to produce an update log with Changes, Adds and Deletes. He would then use this file to update the master file.

My idea would be to produce the current copy of the humongous file and then run a compare program that would generate the Update log. It goes without saying that each record has a unique PK.

My questions:

1. Does this appear to be a sound approach?
2. Is there a quicker way to compare records other than looping thru each field in the record?

Thanks,

Yossi