Data Validation

[eric.kung]

Dear All

My name is Eric Kung, I am a new member of the forum.

The reason I joined because I have a question which I would like to ask.



Currently I have 2 files.
Both files have 2 fields which are exactly identical (in terms of field name, field content etc.).
The field is: File_name.

Now I would like to develop a program using MS Excel to validate these two files and see whether anything from these files are missing.

Under the field: File_name there are many file names.
The format is similar to this: 20110812_FRI


Is it possible to create a program to allow it to automatically validate the two files (The file is CSV file, and it is being automatically imported to access file.) and create an alert IF found data is missing?

Is it then possible for the ALERT or some kind to display which files are missing?

Is this possible?
Is this possible to be done with MS Excel?

 

[nightcrawler23]

Do you want to compare two csv files row by row and list down the non matching lines??

 

[eric.kung]

Do you want to compare two csv files row by row and list down the non matching lines??

Dear nightcrawler23

That would be my intention, yes.

I would like to compare row by row.

Since the field file_name suppose to have same value.
Is there a comparing tool like that exists?