Create AccessDB with contacts from EXCEL
$30-250 USD
Paid on delivery
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
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!!!!
Project ID: #506101
About the project
Awarded to:
70 freelancers are bidding on average $69 for this job
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
dear sir I would like to inform you that i have 15 years experience excel and access. please see my pmb. thansk asad
i have 8 yrs experience in visual basic, access and i can transefer the 11,000 record in an hour or less using a VB programe i created to do this job
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.
I have worked on access and excel projects during my full time work. I would be able to do this effectively