Create a database (Using SQL, php, etc). Create interface that merges database records with CSV./Excel files.

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

•••Important note, I have an Apple Macbook computer. This must be done for MAC OS. I cannot use Microsoft Windows based programs.•••

Project Number 1:

I have 2 different lists. One list is a CSV file with every business in a certain state in the USA. The list includes business/entity name, the people who own and operate the business, the business address etc. The other list(s) are lists I purchase that have business names and the real estate those businesses own. We will call this the REAL ESTATE list. I buy these lists regularly so I need the program you create to be able to allow me to easily run new lists in the future. These lists do NOT have the names of the PEOPLE who own and operate the businesses. I need you to create a database from the CSV list file that has every business in the state. This list has nearly 5,000,000 business name, owners etc. We will call this the business OWNER database.

Project Number 2: I need the business OWNER database to communicate with REAL ESTATE list to merge OWNER info with REAL ESTATE info to create a new CSV/Excel sheet with all of the merged data.

You will need knowledge of how to create a database. Likely, you will use SQL, php etc. There are millions of entries in the Excel/CSV files so a simple VBA will not work.

Database Development Excel Macros Excel VBA PHP SQL

Project ID: #17220060

About the project

27 proposals Remote project Active 5 years ago

27 freelancers are bidding on average $186 for this job

schoudhary1553

Hello, I can help with you in your project Create a database. I have more than 5 years of experience in Database Development, Excel Macros, Excel VBA, PHP, SQL. We have worked on several similar projects before! We More

$250 USD in 3 days
(166 Reviews)
7.3
Ginjag

Hi, I am interested in your project. I have experience on website development. Special is on website development. I have ever built some systems on PHP. I can show you some my completed PHP system. Let me explain a More

$300 USD in 7 days
(209 Reviews)
7.3
rodweb

Hi, I apply for this job. I think to be the right candidate for this job as i have good skill in sql ,php and also Have a Mac computer Hope to Have a chat with you Thanks

$188 USD in 3 days
(57 Reviews)
5.8
vw8092236vw

I have 5 years of experience in mysql and php . I have done alot merging with big databases Feel free to contact me.

$100 USD in 3 days
(53 Reviews)
5.1
worldscript

I have 8+ years in web designing & development with good experience in following skills ... 1. HTML5 2. CSS,CSS 3 & LESS 3. JS (Angular JS, Backbone JS,React JS, node.js, expresss JS, Gulf JS) 4. Java Script & Jq More

$45 USD in 3 days
(26 Reviews)
5.2
doxan

Hi, my name is Andrey. I have extensive experience with accounting systems, CRM, ERP, web-based databases, report(xlsx,docx,pdf). For example in my portfolio i have some projects. Let's see them. I’m absolutel More

$277 USD in 5 days
(15 Reviews)
5.1
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$155 USD in 10 days
(23 Reviews)
4.8
hemsingh1

Excel, VBA, MS Access & SQL Expert with over 5+ years of experience. Should be able to help & design a solution as needed. Thanks

$250 USD in 7 days
(84 Reviews)
5.8
pictuscode

Hi, Trust you are doing good. We have dedicated team on PHP and we can start working on your project right away, let’s discuss your requirement in more detail Our Expertise A thorough understanding of develop More

$222 USD in 3 days
(2 Reviews)
4.3
prasannjeetp

Hi, I have seen your proposal. I am an excel expert/web designer with very good knowledge of VBA, PHP, SQL database. I can make this programme using the combination of VBA, PHP, SQL to make it work your way. I will do More

$100 USD in 3 days
(19 Reviews)
4.2
abubakar4248

hey i am a professional software engineer having +3 years experience in this field i have lots of expertise in database development and php language i will provide quality. work we can discuss details over chat regards

$50 USD in 1 day
(6 Reviews)
3.6
kitty120

hello sir I have a 3 years of experience in php as j have read your requirement and I can easily complete your work within given date and time thanks

$50 USD in 1 day
(6 Reviews)
2.6
lamontef

I've been writing PHP/MySQL code for over 20 years and have recently completed a project very similar to what you are looking to do (taking business lists and importing them into a database). I'm assuming that you do n More

$250 USD in 5 days
(0 Reviews)
0.0
Hechi193

Hello, are you looking for a database expert. my team have 13 years of experience in development. were professionals in php, codeigniter, C#, database, MVC. we will do an excellent work done for you. thanks

$250 USD in 10 days
(0 Reviews)
0.0
databasengineer

hey i can create front end on ASP.Net and Sql Server at very cheap price. that accept .CSV and EXCEL file software get data from files and save it into database, also you can view your data on your application.

$150 USD in 7 days
(0 Reviews)
0.0
souravidec

Hi, I have been doing such work from last 5 years using oracle and excel. So I can very well serve you result still i have kept my bid low because i am new here and getting work will be my priority.

$80 USD in 5 days
(1 Review)
0.0