Microsoft Access/SQL Files validation and comparison

$30-250 USD

Completed

Posted

almost 12 years ago

$30-250 USD

Paid on delivery

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. Thanks Rob

Microsoft Access

MySQL

SQL

Project ID: 2341234

About the project

14 proposals

Remote project

Active 12 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@torajiv

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

$50 USD in 3 days

4.9

(154 reviews)

6.8

14 freelancers are bidding on average $73 USD for this job

@winnet21

Hi, I have experience in this project, looking forward to working with you in this project Regards

$30 USD in 2 days

4.7

(37 reviews)

5.8

@thanhlongfree

Hello. Please check PM

$40 USD in 2 days

4.5

(22 reviews)

5.4

@Nhcuong

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 database? Can you please send all sample files: excel, text file and access ( if needed) so i can get what you need. Looking forward to hearing you, Cuong NH

$100 USD in 4 days

4.9

(5 reviews)

3.3

@Specialists786

I have a message for you in PMB

$30 USD in 1 day

5.0

(2 reviews)

2.5

@MatKauton

PM for details.

$35 USD in 2 days

5.0

(3 reviews)

2.6

@lentzka

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 in 2 days

5.0

(1 review)

1.8

@darkostrbac

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

$100 USD in 2 days

0.0

(0 reviews)

0.0

@mattmixon

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 Excel. See PM for further details of my bid.

$200 USD in 2 days

0.0

(1 review)

0.0

@mrexcel2012

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 solution and help you in all your vba related problems on time. KEVIN

$30 USD in 1 day

0.0

(0 reviews)

0.0

@PITHYD

Hi please check your mail box

$30 USD in 2 days

0.0

(0 reviews)

0.0

@sidik999

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

$30 USD in 3 days

0.0

(0 reviews)

0.0

@RuchiraVindana

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 in 5 days

0.0

(0 reviews)

0.0

@mslancer2012

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 between applications takes place and you're looking at identifying the same differences. Please contact me so we can discuss further details. Thanks

$150 USD in 2 days