Project Detail

Excel File modification

Excel File modification is project number 172896
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: DataHome

Budget: $30-100

Created: 08/31/2007 at 0:45 EDT

Bid Count: 3

Average Bid:
$ 62

09/01/2007 at 0:45 EDT

Project Creator: Rebelnetworks offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (13 reviews)

Description

We need to clean up a large excel file for importing into a SQL database. Your requirement for this project is simple, but could be time consuming.

so the file is large -
it currently contains about 30,000 funeral homes
they is about 90% duplicate data

remove the duplicate funeral homes providers (duplicate records)
add in the codes for state and city that will be provided

so the final excel document will show around 18,000 funeral homes
and have some codes for city and state that can be used to import into a MS-SQL database

with each one you will need to put in the city code and the state code from a list provided.

I believe a small excel macro or script can be created to accomplish this.

the files are very large and can not be uploaded here

please submit your bid as i need to have this file back by Sept. 2 the latest

Report Violation

Job Type

See more: bid, code, excel, excel file, excel macro, file, import, list, macro, project, script, small, sql, sql database, submit

Messages Posted:0

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

PMB

2 days

08-31-2007 00:50 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(53 reviews)

Hello there, we are ready . pls read PM

noushadaxis offline

1 day

08-31-2007 00:56 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Please check PM. thanks

Fiishee offline

2 days

08-31-2007 00:58 EDT

(No Feedback Yet)

it's ok for me...i m ready ...

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.