En cours

Microsoft Access/SQL Files validation and comparison

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.



Compétences : Microsoft Access, MySQL, SQL

Voir plus : sql microsoft access, ms access sql, microsoft access sql, attached files, validation, sql projects, similarity, reusable, report sql, ms access email, excel to sql, excel to my sql, email validation, data validation, access sql, access microsoft, code columns excel access, excel access table, compare similarity, compare rows excel, compare columns excel access, excel compare columns data, sql report access, sql email, microsoft mini sql

Concernant l'employeur :
( 27 commentaires ) Toronto, Canada

N° du projet : #2341234

Décerné à :


VBA expert here - am giving you a solution in PM - Thanks - Rajiv

50 $ USD en 3 jours
(147 Commentaires)

15 freelance ont fait 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

30 $ USD en 2 jours
(36 Commentaires)

Hello. Please check PM

40 $ USD en 2 jours
(22 Commentaires)

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

100 $ USD en 4 jours
(5 Commentaires)

I have a message for you in PMB

30 $ USD en 1 jour
(2 Commentaires)

PM for details.

35 $ USD en 2 jours
(3 Commentaires)

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.

150 $ USD en 2 jours
(1 Commentaire)

Hello, this is a simple and small Project. In two days is this complete! Thank's

100 $ USD en 2 jours
(0 Commentaires)

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

200 $ USD en 2 jours
(1 Commentaire)

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

100 $ USD en 2 jours
(0 Commentaires)

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

30 $ USD en 1 jour
(0 Commentaires)

Hi please check your mail box

30 $ USD en 2 jours
(0 Commentaires)

7 years experience in Visual Basic 6. Im interested for the job.

30 $ USD en 3 jours
(0 Commentaires)

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.

50 $ USD en 5 jours
(0 Commentaires)

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

150 $ USD en 2 jours
(0 Commentaires)