I have several Excel files containing business contacts information. At all about 11.000 contacts and about 25 different excel files.
I want to migrate these contacts into one MS Access Database containing minimum these fields
Company
First Name
Last Name
Job Title
Street
City Code
City
Country
Telephone
Fax
Website
email
The source excel files are slightly different in colum names and wording.
Goal: Have all data from excel files into Access 2007 DB format
Export Duplicates into external data
Make Data searchable and exportable
Attached you find the sample database - you find two demo excel files with data.
!!!!Offers only with demo data in DB - and Search and export function!!!!
VBA Guru. Experience of 8 Yrs Fully documented code can be provided. Need be, a pdf file can also be supplied explaining the installation (if applicable), or any other relevant documentation
I am an IT professional with 10 yrs experience. I have very good experience with Ms-Access. I have completed many projects on GAF in Ms-Access skill.
I will provide quick & professional service.