В роботі

Access database question

I have an access database of about 450,000 company & personal names, addresses, etc.

There are tons of duplicate records in the database, but they are not exactly duplicate.

Some records may have Joe Construction Co and another will be Joe Construction Co Inc, etc.

There may be times where there are 6-9 duplicate vendors each with slightly different information. What I am trying to is combine all the duplicate records into one single record. I have to make the single record contain the most data possible.

For example, in the database there are about 20 fields. Some duplicate vendors may have the companies ethnicity information in one record, the next duplicate record may have the company's vendor number, the next record may have a phone number that the previous two records did not have, etc. I want to combine all the data into one record with the most data.

Attached is a sample of the database I am working with. This one only contains about 4,000 names just to give you an idea of what I am up against. The solution needs to be able to be done on the complete database of 450,000 records eventually.

If you have any questions, please feel free to ask.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

access 97

Навички: Техніка, Microsoft Access, MySQL, PHP, Архітектура ПЗ, Тестування ПЗ

Показати більше: what is engineering all about, questions to ask companies, ask any question, any question, access vendor database, access database software, database vendor, s joe, question 4, Construction Engineering, companies database, c# with access database, c with access database, access database, access construction, database question, company names database, access form record, access sample program, vendors access, database names addresses, combine access database, complete access database, vendor database access, access vendors

Про роботодавця:
( 105 відгуки(-ів) ) United States

ID проекту: #2965738

Доручено:

sixi

See private message.

$6.99 USD за 2 дні(-в)
(11 відгуків(-и))
2.7

6 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $11

jsmorgan24

See private message.

$12.75 USD за 2 дні(-в)
(30 відгуків(-и))
4.2
captainjoe

See private message.

$12.75 USD за 2 дні(-в)
(13 відгуків(-и))
3.4
webffiliates

See private message.

$12.75 USD за 2 дні(-в)
(19 відгуків(-и))
3.7
alekseychabunin

See private message.

$12.75 USD за 2 дні(-в)
(5 відгуків(-и))
2.6
thecustomizer

See private message.

$8.5 USD за 2 дні(-в)
(0 відгуків(-и))
0.0