MS Access List Work Clean Up & Remove Duplicates

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.

Habilidades: Processamento de Dados, Processamento de dados

Ver mais: access remove duplicates, access list, work clean list, cleanse access, remove duplicates access table, list cleanup work, remove access list, work it up, up as, my email address is invalid, ms processing, ms access work, invalid email error, invalid email addresses, data entry ms access, data entry in ms access , list duplicates access, clean remove office, remove duplicate access retaining information, access delete duplicates vba function, remove access logo name, access list creator, access vba find find duplicates, state list access, access clear list data

Acerca do Empregador:
( 45 comentários ) Nashville, United States

ID do Projeto: #144262

Premiar a:


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 ca Mais

$50 USD em 2 dias
(1 Comentário)

50 freelancers are bidding on average $59 for this job


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

$60 USD in 5 dias
(216 Comentários)

My bid includes the sorting of valid emails.

$100 USD in 6 dias
(69 Comentários)

experience+timing=garbar regards garbar

$50 USD in 4 dias
(69 Comentários)

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

$60 USD in 2 dias
(75 Comentários)

Hello, Please see PM for details. Thank you.

$47 USD in 4 dias
(25 Comentários)

Hi, See my PM now ASAP. Thank you.

$75 USD em 1 dia
(45 Comentários)

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

$70 USD in 7 dias
(26 Comentários)

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

$80 USD in 7 dias
(9 Comentários)

Please see detail on PMb. Regards

$90 USD in 5 dias
(3 Comentários)

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 progra Mais

$89.95 USD in 2 dias
(5 Comentários)

Hi! Please read PM

$100 USD in 5 dias
(13 Comentários)

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

$30 USD in 3 dias
(3 Comentários)

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 Mais

$60 USD in 3 dias
(1 Comentário)

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

$65 USD in 3 dias
(1 Comentário)

Please check pmb

$30 USD in 5 dias
(1 Comentário)

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 Mais

$100 USD in 7 dias
(1 Comentário)

hi,please check PMB

$30 USD in 0 dias
(1 Comentário)

Please see PMB

$30 USD in 5 dias
(1 Comentário)

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

$30 USD in 7 dias
(1 Comentário)

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 i Mais

$31 USD in 2 dias
(0 Comentários)