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.