Concluído

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

Veja 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

Concedido a:

RickM

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)
1.6

49 freelancers estão ofertando em média $58 para esse trabalho

LK1811

My bid includes the sorting of valid emails.

$100 USD in 6 dias
(74 Comentários)
6.8
ggopi

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

$60 USD in 5 dias
(221 Comentários)
6.6
best4best

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

$60 USD in 2 dias
(148 Comentários)
6.4
garbar

experience+timing=garbar regards garbar

$50 USD in 4 dias
(72 Comentários)
6.2
yahya07

Hello, Please see PM for details. Thank you.

$47 USD in 4 dias
(26 Comentários)
4.8
asaikiran1979

Hi, See my PM now ASAP. Thank you.

$75 USD em 1 dia
(44 Comentários)
4.9
stungscorpion

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

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

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

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

Please see detail on PMb. Regards

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

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
(4 Comentários)
3.4
AncaU

Hi! Please read PM

$100 USD in 5 dias
(12 Comentários)
3.3
chrwei

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)
2.8
ajay192

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

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

Please check pmb

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

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)
1.3
vinaykum

hi,please check PMB

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

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

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

Please see PMB

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

Please check PM.

$100 USD in 7 dias
(0 Comentários)
0.0
tsm247md

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

$99 USD in 7 dias
(0 Comentários)
0.0