Closed

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

•••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.

Skills: Database Development, Excel Macros, Excel VBA, PHP, SQL

See more: csv update sql php, howto export data csv excel format php mysql, count records using nusoap php, import csv file into mysql using php code, how to export mysql data in csv/excel file using php/mysql, how to import xlsx file into mysql database using php, export csv file in php, how to read csv file in php and store in mysql, import excel to mysql using php example, download csv file in php example, upload csv file in php example, php, excel, csv, edit xml files using php interface, program using php interface, making excel files large database, upload csv file web using mysql php, poi read excel files insert database, csv excel using perl

About the Employer:
( 11 reviews ) Somerville, United States

Project ID: #17220060

31 freelancers are bidding on average $185 for this job

$250 USD in 5 days
(972 Reviews)
8.7
minhhoangduc

Hello, I'm a PHP, Drupal, WordPress CERTIFIED EXPERT coder. And have a lot of experience with Codeigniter, Laravel, System admin + Html + Javascript + CSS + API integration Please have a look at my Portfolio and c More

$555 USD in 5 days
(566 Reviews)
8.1
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
(105 Reviews)
6.7
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
(42 Reviews)
5.8
$155 USD in 3 days
(37 Reviews)
5.8
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
(46 Reviews)
5.5
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
(56 Reviews)
5.3
isyncevolution

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } CSV to Mysql DB 12 Yrs. Exp. in Web Software Development , Design & SEO. I am good in existing site issue solving as well as add new feature to exis More

$140 USD in 30 days
(26 Reviews)
4.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
(41 Reviews)
4.9
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
(16 Reviews)
4.6
Agiletechstudio

Hi, there i read your initial requirements and i have some question regarding to your merge excel record [login to view URL] can we discuss it on chat ?

$100 USD in 3 days
(17 Reviews)
4.8
vinisaac

I am in Chicago, USA. I would like to work on your project. I have more than 25 years of experience in web/software development and system administration. My latest work is [login to view URL] Have worked More

$250 USD in 10 days
(8 Reviews)
4.5
katilinas

Dear Employer, I'm ready to work on "create a database (using sql, php, etc). create interface that merges database records with csv./excel files." project. I have 5 years experience in SQL, Database Development, Exce More

$150 USD in 2 days
(9 Reviews)
4.6
$155 USD in 3 days
(9 Reviews)
4.1
maximwang8661

Hello How are you? Thanks for your reading my proposal. I 've read your project description carefully. So i am interesting in your project. I have many and rich experiences with PHP and SQL. More

$155 USD in 3 days
(11 Reviews)
3.9
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.4
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
(7 Reviews)
2.7
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
(8 Reviews)
3.1
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
(3 Reviews)
1.8
miraymond

Hello! ADD: (Open the csv file as a normal binarization file, merge the two, and save it as csv again. Leave it to me. I'll do great. PHP functions is as following: fopen(), fread, fwrite(), fclose() if you use thi More

$155 USD in 3 days
(1 Review)
1.4