Find Jobs
Hire Freelancers

Create Prospects Database from My Data

$100-300 USD

Cancelled
Posted almost 18 years ago

$100-300 USD

Paid on delivery
I have 170 files of miscellaneous leads that I have acquired over time. I have uploaded one very small one as a sample. I would like them loaded into a single custom database. I started with an MS Access template for Contacts Database, and added fields to make it ‘look’ like it should. First step is to add the database fields, finish the entry forms (for new tabs), and make sure the database is working correctly. Each of the source data files has a different format. It’s very important to me that no data is lost. At a minimum, each record should have a first name and some contact information (e-mail, phone, or mail address.) The name fields may be any combination of the following and more: - Firstname. Lastname. Fullname. – all 3 as separate fields - Firstname Middleinitial Lastname – we need to extract the first name - Lastname, Firstname – the first name needs to be extracted and the full name re-written as Firstname Lastname with no comma - Companyname – I don’t want “The Acosta Group” to be firstname=“The” - Any combination of the above, even within the same file All through the data, some may be in ALL CAPITALS, some in all lower case – everything should be standardized as Title Case. So, MARY or mary is entered as Mary. Phone numbers should look like phone numbers (650) 555-1212 for US, +33 6 5544 3333 for international. I would like the Time Zone filled in for US phone numbers. There is a time zone lookup table in a number of the source files. Many of the files have no header line, so they will take a little inspection to figure out the appropriate columns. The source data files are in .txt, .csv, and .xls formats, with the columns in different order, some with more data, some with less. So, each file will require some handwork to get all the data uploaded to the database. As each file is loaded into the database, I want to mark each contact record with the File Name and Date of the file, so I have a source for the information. The File Name and Date are shown in the Additional Info tab in the database. Once all the data is loaded, duplicates should be eliminated if there are phone numbers, e-mail or mailing addresses that are identical. I would like the ability to either upload a new data file as I get it, or a low-cost agreement with you to upload each new file. For example, if I buy 50,000 new leads, you'll convert/upload them for $5 or something. Or I need some utility to make this easy. Finally, I would like to be able to extract records from the database easily. E-mail only, including e-mail, phone number only, including phone number, dated this year only, US only, foreign only, with mailing address, etc. The 170 data files total 331 MB of data. So the resulting database will also be quite large - the freelancer will need to have a site where we can FTP the files. So, the starting point is working out how to get you the data files. Hopefully this is all pretty quick and easy for someone with the appropriate skills and tools. Please provide bid, time frame, relevant experience, and why I should choose you. Best regards and happy bidding, Don
Project ID: 53560

About the project

39 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average $169 USD for this job
User Avatar
Clearly understood. Please be assured of 100% accurate work as per your requirements. I will do it by writing a program. Thanks, Krishan
$110 USD in 5 days
4.9 (74 reviews)
6.8
6.8
User Avatar
Please see PMB for details.
$300 USD in 7 days
4.7 (9 reviews)
5.0
5.0
User Avatar
We will do this for you in a professional manner. Regards, Biro Carol
$120 USD in 4 days
5.0 (1 review)
3.0
3.0
User Avatar
Your requirements can be executed as a project in MS Access. Please see PM for further details
$220 USD in 4 days
5.0 (1 review)
1.8
1.8
User Avatar
kindly refer my PMB, thanks
$110 USD in 5 days
5.0 (2 reviews)
1.6
1.6
User Avatar
Sir, I'm an iit ug. I've expertise in data processing area. I'll also provide you with easy tool to upload data as well as retrive data. thank you :-)
$120 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a lot of experience in this kind of work. Please give me a chance.
$100 USD in 5 days
0.5 (1 review)
1.0
1.0
User Avatar
I am an Engineering Graduate from JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY Andhra Pradesh, India. Furthermore, I am genuinely interested to become an asset of your esteemed organisation. Why You should hire me? Because, this project fits under my expertise. And i am looking to work with you for 12- 15 hours a day, to produced an accurate n neat work on time. And iam gonna charge as per your terms. THERE IS NO LIMIT TO HOW MUCH ONE CAN GROW HERE. LOOKING FOR ALL YOUR FUTURE PROJECTS. I already worked with same kind of projects, with INFORMATION PACKAGING COMPANY, AUS. This really fits under my expertise. Desperate to start rite from 2day.
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Please try me I promise I'll give you 200% satisfaction in this work.I Work with my pc the whole day since I was in school.I know harwares , softwares and lots
$120 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am well versed with Access data base, after going thru the details of the project, i found that it is kind of data processing, not exactly data entry, some minor typing for modifications once data is transferred to data base, still it is hard to make real estimate for the price, as i dont know how much data in each files is present, and how much modifications will have to be made, but yes my rough estimate on lower side is 300$
$300 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 4 years experience in providing administrative support and have successfully completed many projects. Please see PM for details.
$250 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am a professional IT developer. I have a strong data entry TEAM. So you can rely on me. Thanks, Rukun
$150 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
ready to start.
$100 USD in 6 days
0.0 (0 reviews)
1.4
1.4
User Avatar
It is very interesting I have done similar manipulations. I am confidant of giving neat job.
$125 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I would enjoy doing this work for you. Take a look at my PM.
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, We are pastmaster in excel/access and know all advance formulas. Please see the PMB>
$100 USD in 7 days
0.0 (0 reviews)
1.4
1.4
User Avatar
i will do this
$125 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do it quickly with help of some tools, I did it many times, however since the total file is quite big please compress in .zip divided into 4-5 files maybe 30files/zip file, I have a ftp site and DSL connection. I also need to build up my first portfolio :) Thanks - Donny
$100 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Just finished a similar project. I would be glad to do this for you. It can be written in visual basic so that you can later customize your imports with very little effort (drop down combos/file tree) or help from anyone else. Can be done to your satisfaction. Thank you, Gary
$300 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience with databases, especially Access.
$300 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Pacifica, United States
5.0
3
Member since Mar 11, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.