Em Andamento

Excel File modification

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

Habilidades:

Ver mais: we excel, simple file database, data modification excel, n excel, macro excel, excel file, excel duplicate, excel add, excel submit, excel contains, macro script file, excel macro add, macro large database excel, state code, import data macro excel, simple script excel, excel list files add, script clean list, large file, script excel sql, sql script import excel, need modification, duplicate file, import excel sql script, add excel macro

Acerca do Empregador:
( 28 comentários ) Mississauga, Canada

ID do Projeto: #172896

Premiar a:

DataHome

Hello there, we are ready . pls read PM

$80 USD em 2 dias
(110 Avaliações)
6.3

3 freelancers estão ofertando em média $62 para este trabalho

noushadaxis

Please check PM. thanks

$60 USD em 1 dia
(1 Comentário)
0.0
Fiishee

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

$45 USD in 2 dias
(0 Comentários)
0.0