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