I need a code or a method to compare the similarity of two excel files' data in MS Access 2003 in a way that it will show if it "Passed" or "Failed", and if it Failed the validation, i need a clear report or table of all the unmatched cells.
Each of the two files is consisting of 27 to 28 columns, and +88,000 rows.
The code is preferred to be simple and reusable with other similar files.
I have attached the two files i want to compare (one of them is in txt format) . please feel free to email me if you have any questions.
please note that my budget is very limited but i have many of those mini-projects.
15 freelance font une offre moyenne de $75 pour ce travail
Hi, I have experience in this project, looking forward to working with you in this project Regards
hi, i can do it with VBA in access and/or excel? please give more detail requirements about check/validate a file. Do you have 1 original and need to check other txt/excel file against it before importing into a datab Plus
Hi, I have written file comparison functions for other clients and am sure I can help you. I will write in such a way, so that it can be reused.
I am a professional programmer with 15 years experience and possess an MCAD .NET certification from Microsoft. I am proficient in all of the Microsoft development platforms including MS Access, Visual Basic, SQL, and E Plus
Since 2001, I have specialized in designing, developing, and maintaining MS Access databases. I am presently a corporate database engineer specializing in MS Access, SQL, Visual Basic, and SQL Server. Since 2007, I hav Plus
Hi Iam excel macro developer and developed many solutions on this platform. Iam also attaching screenshot of sample application developed for one of my earlier client. I assure you if awarded, i will deliver the so Plus
Over 5 years experience in utilizing the whole suite of Microsoft Office products and Visual Basic. I would like to atest my skills and talent to fullfill your job.
Hi, I have extensive experience in very similar applications. I can definitely do this for you and provide a step by step written process so you can do-it-yourself on a go forward basis given the same exchange betw Plus