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


Daha fazlasını gör: we excel, simple file database, import ms project, excel &, data modification excel, n excel, macro excel, macro + excel, import excel, file, excel\ , excel, excel to sql, Excel file, excel duplicate, excel c#, excel add-in, excel add in, c# import excel, c import excel, excel submit, excel contains, macro script file, excel macro add, macro large database excel

İşveren Hakkında:
( 28 değerlendirme ) Mississauga, Canada

Proje NO: #172896



Hello there, we are ready . pls read PM

%selectedBids___i_period_sub_7% gün içinde 80%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(110 Değerlendirme)

Bu iş için 3 freelancer ortalamada $62 teklif veriyor


Please check PM. thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)