Project Detail

MS Access List Work Clean Up & Remove Duplicates  

MS Access List Work Clean Up & Remove Duplicates is project number 144262
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: RickM

Budget: $30-100

Created: 05/09/2007 at 17:08 EDT

Bid Count: 50

Average Bid:
$ 59

05/16/2007 at 17:08 EDT

Project Creator: cassman
Employer Rating: 9.9778/109.9778/109.9778/109.9778/109.9778/109.9778/109.9778/109.9778/109.9778/109.9778/10 (45 reviews)

Bid On This Project
 

Description

I have a list of about one million contacts in approximately 50 different MS Access tables, of which different tables are different states or other categories of contacts.

Approximately half of the contacts have email addresses. I need a version which has deleted all those without email addresses. Also, I need this version simplified into state by state tables so I have only 50 tables (right now other tables include data extracted by company or other criteria).

Additionally, I need the list cleaned of any duplicate email addresses or those where there is an obvious error, such as the inclusion of a ! or $ or other invalid character in the address.

Also, I need a standardized naming of the columns within the database for all of the output. This would include Name, Phone, Address, City, State, County, Zip Code, Email, Phone, Fax.

Finally, each contact has a current field for 'Name'. While retaining this information, I need a new field created where the first name of the contact has been extracted into the new field and the original name retained, so that my new list will have a category 'Full Name' containing all of the original data as well as a category titled 'First Name'.

ADDITIONAL: My list is old and from experience about 30% are bad email addresses. If you are capable of accurate cleaning my list of invalid email addresses, I will pay extra for this. I attempted to do so using a software for sale, but I found that it was not accurate in identifying good or bad addresses. Please specify if you can accomplish this additional task. Otherwise I will create a separate project for this.

Messages Posted:3 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

 

60

5 days

05-09-2007 19:01 EDT

I'm Gopi from India. Please check my PMB.

help

 

75

1 day

05-09-2007 17:18 EDT

Hi, See my PM now ASAP. Thank you.

help

 

50

4 days

05-13-2007 07:11 EDT

experience+timing=garbar regards garbar

help

 

100

6 days

05-10-2007 08:46 EDT

My bid includes the sorting of valid emails.

help

 

70

7 days

05-09-2007 22:36 EDT

Hi, I would like to bid on this project. Please see PM. Thanks, stungscorpion

help

 

47

4 days

05-12-2007 11:11 EDT

Hello, Please see PM for details. Thank you.

help

 

60

2 days

05-10-2007 00:19 EDT

Hi, I can handle your project efficiently. Please see PMB. Thanks

help

 

89.95

2 days

05-09-2007 19:34 EDT

You'll need a seperate project for Email verfication (assuming that it can be done effectively under today's stricter privacy guidelines.. {sigh}). Hello my name is Bill.. I am a VB, VBA, SQL and MsOffice programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed several GAF projects, so you can find additional references for me here. I have 20+ years of hands-on Programming and Business Information System experience. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving ALL of your goals in your every endeavor. Respectfully, Bill.

help

 

80

7 days

05-12-2007 10:57 EDT

Ready t work at once And can also provide email authentication.

help

 

30

3 days

05-10-2007 03:19 EDT

i can do this, but your additional task is different and i think we can discuss that later. So wait for your answer =)

help

 

65

3 days

05-09-2007 23:16 EDT

Your project requires patience and accuracy. We have both. Please check PMB for details.

help

 

30

5 days

05-10-2007 03:22 EDT

Please check pmb

help

 

90

5 days

05-12-2007 15:53 EDT

Please see detail on PMb. Regards

help

 

60

3 days

05-09-2007 20:17 EDT

Hi, I'm new to GAF but don't let that scare you. I have 10+ years of experience with Access. Email verification would be separate bid, and you are correct that it can't be done with 100% accuracy, but it can be done with reasonable accuracy and without deleting a contact that does have a valid email address. Check PM for more info

help

 

30

0 days

05-09-2007 23:16 EDT

hi,please check PMB

help

 

50

2 days

05-09-2007 17:53 EDT

Hi, my name is Rick. I could do this data scrubbing in 2 days. Do you have any needs in working with the data after it is cleaned? Maybe creating a few queries would make the data easier for you to manipulate. I can start work on the data scrubbing immediately, so please contact me if you would like to discuss this project further. Thanks.

help

 

30

7 days

05-09-2007 22:33 EDT

Hello Sir! Please refer our PM for detailed bid. Thank U!

help

 

30

5 days

05-11-2007 19:45 EDT

Please see PMB

help

 

50

1 day

05-09-2007 18:09 EDT

(No Feedback Yet)

The job will be done with Precision & Accuracy. GUARANTEED!!! More on PMB...

help

 

100

5 days

05-09-2007 20:53 EDT

(No Feedback Yet)

Kindly refer to your PM... Thanks!

help

 

85

7 days

05-09-2007 21:45 EDT

(No Feedback Yet)

As you have said that you have millions of address list, Finding the wong entries and cleaning them will take some time to do it properly, therefore I have said i would require 7 days approximately, since you also want a copy of thos addresses which have errors in them, please let me know more about the details and your view. Regards, krishna77

help

 

40

3 days

05-09-2007 22:43 EDT

(No Feedback Yet)

Hi, I can do this job very efficiently. Please check PMB for more discussions, Thanks and regards.

help

 

100

10 days

05-09-2007 22:58 EDT

(No Feedback Yet)

Hello sir, I am ready to do this work for you.. Please Check PM for my resume that attached.. Thanks, Naga.

help

 

40

5 days

05-09-2007 23:08 EDT

(No Feedback Yet)

i can do this job

help

 

100

5 days

05-09-2007 23:19 EDT

(No Feedback Yet)

Hi! Please read PM

help

 

50

3 days

05-10-2007 00:53 EDT

(No Feedback Yet)

i can do all work

help

 

30

3 days

05-10-2007 01:05 EDT

(No Feedback Yet)

hi... I'm maria, excelent in data processing

help

 

30

3 days

05-10-2007 02:12 EDT

(No Feedback Yet)

Hi! I'll clean your base, but without mail verification.

help

 

30

20 days

05-10-2007 23:23 EDT

(No Feedback Yet)

will do the clean up work within 20 days for just 30$

help

 

30

10 days

05-10-2007 03:09 EDT

(No Feedback Yet)

Hi, I have already worked in Access. So, Iam confident I can do this work. I can assure you with the accuracy of the work. Please inform me if iam suitable.

help

 

30

10 days

05-10-2007 04:26 EDT

(No Feedback Yet)

Hi. I can do this. Looks pretty easy however it may take a few days.

help

 

75

5 days

05-10-2007 04:28 EDT

(No Feedback Yet)

I will stroe the data in oracle database and using sql queries i will do the job.I have experience in this field for about 3 1/2 years.I have worked for many MNC's.

help

 

50

15 days

05-10-2007 04:39 EDT

(No Feedback Yet)

Dear Sir/s, Here we are looking for an opportunity to work for you off-line or on-line as a Vendor, and if there is any real possibilities please keep us informed. We have set of people to start our own business. We have around 4 years experience in BPO Medical Billing industry here in India and looking for any kind of OUTSOURCING work from your end. We assure you to give quality work at all times, so that we could improve if you are really satisfied on our works. Thanks & Regards Manikandan.N Place: Chennai, India Date : May8th, 2007

help

 

30

2 days

05-12-2007 12:29 EDT

(No Feedback Yet)

Hi, I can do the work in two days. I am seriously looking for the work which i can do from my home. I have an exp of 10 yrs.

help

 

40

2 days

05-10-2007 07:43 EDT

(No Feedback Yet)

I have been working with access for over five years and I am capable of designing and implementing excellent databases concepts. I would do this as quick as possible.

help

 

50

5 days

05-10-2007 08:00 EDT

(No Feedback Yet)

We can assure you for the successful completion of this project. I suggest you to have a seperate project for varifying the email ids.

help

 

50

3 days

05-10-2007 08:29 EDT

(No Feedback Yet)

Hi, I am good in data processing with MS office. I can do this project with 100% accuracy. I have more than 5 years experience and I am currently doing my masters in Corporate Finance, thank you

help

 

100

7 days

05-10-2007 10:09 EDT

(No Feedback Yet)

Thank you for the opportunity to submit my proposal for your project. In reviewing your project description, I am certain that I can complete this project within the parameters that you have set. I am an expert in MS Access and can also help with e-mail verification. If selected for the project, I would like to begin working right away on administering this data for you in a succinct way. Please feel free to contact me for quick turnaround. I look forward to speaking with you about this exciting project. Sincerely, Nikki Wright Owner, New Englander Enterprises

help

 

99

7 days

05-10-2007 10:32 EDT

(No Feedback Yet)

Good day, I want to resolve your main task with additional task. I have experience in MS Access, Visual FoxPro, MS SQL, MS Excel. Three steps for resolving additional task: determine potential bad address, second testing potential bad address, transfer potential bad address in bad address base. Thank you. Anatol Goncearenco

help

 

65

10 days

05-10-2007 10:53 EDT

(No Feedback Yet)

We provide all sorts of assistance in your business needs, We use the latest and constantly update our technological needs to handle all administrative tasks. Our infrastructure suits all business requirements from clients across the universe. We deliver solutions with improved performance at lower costs, shortened cycle times, good return on investment, increased productivity levels. Thanks Bharathi

help

 

65

2 days

05-10-2007 11:07 EDT

(No Feedback Yet)

The bid only cover work on clean up and modify layout or out put. Address verifying is not included. It take longer to send email to each address for verificiation and update database.

help

 

45

7 days

05-10-2007 15:59 EDT

(No Feedback Yet)

Please read PMB for cost and offer details.

help

 

60

2 days

05-10-2007 17:14 EDT

(No Feedback Yet)

Hello, I could do this data cleaning job in 2 days. Data processing and data analysis it is my profession. I can't provide you emails verification but name parsing will be the best. Quality is guaranteed. I can start work immediately. Thanks.

help

 

55

4 days

05-10-2007 23:58 EDT

(No Feedback Yet)

Hello, My name is Natasha.I am interested for this project.Kindly consider me for this. Waiting for your positive response. Thanks, Natasha

help

 

75

5 days

05-12-2007 17:40 EDT

(No Feedback Yet)

I am confident I can finish this project in a manner that will satisfy you. The email verification would have to be a separate project however. Please let me know if I can be of assistance.

help

 

30

1 day

05-13-2007 02:48 EDT

(No Feedback Yet)

I can do it with delphi.Thanks.

help

 

100

3 days

05-13-2007 04:52 EDT

(No Feedback Yet)

please see pmb. Regards.

help

 

31

2 days

05-13-2007 10:47 EDT

(No Feedback Yet)

Dear Sir, We have been doing various projects of this nature since 2003. Please give us an opportunity to work for you so that we can prove the quality of our work to you. We have gone through your requirements and it can be completed very fast to your total satisfaction. And your rates too suit us. However, we are ready to offer our services to you totally free in order to make you feel confident about us. Our rates are as follows Per 100 entry: - US $ 1 Regarding the cleaning of invalid email IDs , we will be charging US$ 1 per 10 IDs. We have posted a message about us. Kindly give us a sample job , which we will do at no cost , so that you can assess for yourself regarding the quality of our job. Regards, Firstdata team.

help

 

100

7 days

05-13-2007 19:08 EDT

(No Feedback Yet)

Please check PM.

help

 

50

7 days

05-14-2007 05:00 EDT

(No Feedback Yet)

hi i can do this for you without mistake Thanks

help


    Bid on this Project