The task is to take a number of excel spreadsheets containing contact list records and upload them into Microsoft Access.
The contact lists have different columns. All columns need to be uploaded. But not duplicated - we only want one column for email address, one for company etc. Where there are new data columns they need to be added.
Some of the records have Firstname and Lastname in one field - these will have to be split out into two fields. Although all data columns/fields are to be uploaded there are 15 main columns/fields.
The bigger record files 3 or 4 of them with 1k to 9k records are clean and can be immediately uploaded with no effort at all. The smaller files with 20 to a couple of hundred or more records are the ones where the name needs to be split into two columns (which can be done using conditional statements).
Once all loaded we would ask you to sort them by first and last name, email address, company to identify duplicates and flag them. If you know Microsoft Access this project is straightforward. If you have any questions please ask.
17 freelance font une offre moyenne de £80 pour ce travail
Advanced MS Access developer here. I can help you the data migration. Please check private message box.
Hello, i can help you with this project. Please provide me with some of the files. Thanks.
I have read and understood your project requirement clearly. I am a qualified professionals with few years of experience in Data entry, web design & development, Graphic design and Animation. So far, I have finished mo Plus
Good Day! I would like to apply for the Web Data Research & Data Entry (Upload contact lists into MS Access) position in your company. I have been working in a call center (UK based, 118118, The Number) as a Customer S Plus