MERGE DATA FROM one access 2003 DATABASE to another, (purchased data to telmail data.)
DATA BASE [login to view URL] has several tables with stored data.
Tables are related by the telephone number in each table
DATABASE YYMMDD [login to view URL] has 1 table with several fields. Field names are different from those in the telmail database.
I will supply a table of the fields in the telmail database (TM) and the equivalent field in the purchased database (PD).
Open each table in TM. Search for each telephone number in PD in the TM table. If the telephone number matches, add the data from the PD, to the existing TM field, but do not overwrite existing data. If no matching telephone number exists in the TM table, add it and the related data.
## Deliverables
* * *This broadcast message was sent to all bidders on Thursday May 19, 2011 9:22:02 AM:
I WRITE IN CAPITALS BECAUSE I AM A POOR TYPIST. THIS PROJECT WAS SIMPLIFIED BY HAVING ALL IN ONE MDB WHICH IS NOW ATTACHED TO THE PROGRAM. THE PURCHASED LIST OF NAMES HAS 3000 TO 10000 RECORDS. BECAUSE OF COPYRIGHT RULES, I CAN ONLY SEND A SAMPLE. SEND ME THE CODE AND I WILL EXECUTE THE SAMPLE. I ALSO SEND A TABLE SHOWING INPUTS AND DESTINATIONS. IF YOU CHOOSE, ALSO SEND A BID FOR CREATING A PROGRAM IN WHICH I CAN FILL IN THE BLANKS FOR THE SOURCE AND DESTINATION DATA AND TRANSFER DATA IN OTHER PROGRAMS THAT WE USE. PLEASE BID ON DOING THIS JOB, AS I NEED IT NOW.