Project Detail

URGENT Database merge / script  

URGENT Database merge / script is project number 321429
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: MAnkita

Budget: $30-250

Created: 09/28/2008 at 7:01 EDT

Bid Count: 2

Average Bid:
N/A

09/29/2008 at 7:01 EDT

Project Creator: stretchcomms
Employer Rating: 9.9804/109.9804/109.9804/109.9804/109.9804/109.9804/109.9804/109.9804/109.9804/109.9804/10 (51 reviews)

Bid On This Project
 

Description

This requires IMMEDIATE ATTENTION. I have 1 hour to get this done!

I have 2 databases.

Database 1 (6000 entries) is an old database with teachers details, addresses, telephone, school address etc.

Database 2 (30,000 entries) is a new database of postal codes and a corresponding unique ID.

I need Database 1 to show the unique ID of the school that corresponds to the teacher by checking the entry in post code and comparing it to the unique post codes on Database 2. If it matches a postcode on Database 2 then in a new column on the correct row, it will show the UNIQUE ID from database 2

If there is no match it should say NO MATCH

If there is more than one match it should say DUPLICATES


Additional files submitted:
database2sample.xls
database1sample.xls
finishedexample.xls

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


    Bid on this Project