Create database from CSV then create program that matches/merges database to other CSV/Excel files.

$30-250 USD

Pågår

Lagt ut

nesten 6 år siden

$30-250 USD

Betalt ved levering

**Please note: I have an Apple MacBook. This database and program need to function on MAC OS.** Project: I have 2 different lists. One list is a CSV file with every business in one State in the USA. (4,500,000+ records) which needs to be turned into a usable database. The file includes the business name, the people who own and operate the business, the business address etc. The other list(s) are lists I purchase that have real estate owned by businesses. These lists do NOT have the names of the people who own and operate the businesses, just the business/entity name. The key identifier in both lists is the business/entity name. I need a program to match records from my real estate lists to records in the MA business database and merge the two so the final result includes business name, business owner and operators, and the real estate the businesses own. I buy these lists regularly so I need the program to be able to allow me to easily merge new lists in the future. I know nothing about database design, SQL, VBA, Excel etc. so you would need to advise on the best way to build the database/program and on if it should be hosted locally or have a web based program etc. Thanks!

Prosjekt-ID: 17237511

Om prosjektet

32 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@statAnalysis

Dear customer, looking forward to provide a solution to your business need. I would deliver a web based solution. You just open your browser (safari in your case on mac os) upload both csv files and get the merged vsc for download. Best regards, Joerg.

$99 USD om 3 dager

5,0

(1 omtale)

2,0

32 frilansere byr i gjennomsnitt $176 USD for denne jobben

@schoudhary1553

Hello, I can help with you in your project Create database from CSV then create program that matches/merges database to other CSV/Excel files.. I have more than 5 years of experience in Database Development, Excel, Excel VBA, SQL. We have worked on several similar projects before! We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction.

$250 USD om 3 dager

5,0

(503 omtaler)

8,4

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$250 USD om 10 dager

5,0

(321 omtaler)

7,4

@Yknox

Hello, how are ya? I am Wen. I've read your project details carefully, very excited for checking your brief. I hope you to open chat with me to get discussion about your project more detail. Thanks.

$500 USD om 10 dager

5,0

(24 omtaler)

6,4

@sevillajk01

hi! I can help you. Just give me your files (CSV/Excel) and I'll figure out what I can do. Just want to build you an excel database that is very easy to use. And if you won't like what I do just to pay me. thanks

$90 USD om 5 dager

4,9

(64 omtaler)

5,4

@brianconey

Hello how are you I think it is possible with php and mysql and csv i can merge it as your requirement please contact me I am ready to work and i can start to work immediately thanks

$155 USD om 3 dager

5,0

(9 omtaler)

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 om 10 dager

4,9

(38 omtaler)

5,3

@fleetways

Thank you for looking at our bid, sorry for exceeding max budget. As you want this application on Mac, can we propose a Java based application - - that can import new files as required - You can also export merged records having required columns. Kindly check out my Freelancer portfolio https://freelancer.com/u/fleetways.html for previous work. It would be great if we can get an opportunity to discuss this project further. Thank you.

$833 USD om 21 dager

5,0

(2 omtaler)

5,0

@bestit4u

Hi I am very,very interested in your project My name is Shan Bin and I'm a Chinese developer. I have 6 years of development experience such this projects. I am a highly skilled developer in C, C++, C#, Python, Java, Perl, NodeJS, Reverse Engineering etc. Also I have already experienced with the job similar to this job. Please contact me. Looking forward to hearing from you soon. Best regards. Thanks

$200 USD om 3 dager

5,0

(10 omtaler)

5,1

@sonarkaushik

I am very able to create a vba script to cater your requirement. I am ready to start

$167 USD om 3 dager

4,5

(46 omtaler)

5,6

@kahilH

Hello i am so highly skilled python dev . i suggest a python script to do this work and mysql or postgresql database . i like we discuss more over chat for more details

$55 USD om 1 dag

4,7

(26 omtaler)

4,9

@abhi98041

I am a python expert and i can make you a script that does exactly the same. I can start immediately and can complete it. please check my reviews to see my quality of work. please message to discuss details.

$30 USD om 1 dag

5,0

(11 omtaler)

4,7

@jinigo23

Hey there!! I am ready to provide you the great service from the right away. I've 5+ years experience in this field. And I will be glad to work with you for long term way. I will assure you that you will get a quality work according to your instructions. I'm ready to start the work right now. I am an expert in the following Database Development, Excel, Excel VBA, SQL, C# Programming, PHP, WooCommerce, WordPress, Website Design etc. Regards, George

$210 USD om 3 dager

4,9

(10 omtaler)

4,9

@hsingla85

Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion

$166 USD om 5 dager

5,0

(10 omtaler)

4,6

@prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write VBA programme for you to perform this task and also suggest you the better platform to do with. Please come on chat for more details. Awaiting your response. Thank you.

$50 USD om 3 dager

4,4

(46 omtaler)

4,8

@itbarduga

Hello, Myself Barduga, I have 10+ years of experience in data conversion activity. I have worked on many data conversion projects from Excel spreadsheet to other DB systems. I have developed macros for extracting Excel data. Looking forward for your reply. Please feel free to discuss with me. Warm Regards Barduga

$170 USD om 5 dager

5,0

(7 omtaler)

3,7

@brobb07

1. Excel expert with extensive vba programming experience. I am versed in multiple languages as well as SQL Server, Oracle, MS Access, My SQL. After talking to you more I could advise you better as to which approach would work better for you and whether or not you should host it locally or on the web. I can build a program for you that you can reuse each day to merge new files and merge them into the new database. I do work similar to this regularly. 2. I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. 3. I would start by committing to 3 days but this depends on the scope and could change 4. I have an extensive background in Excel. I would love to know more about your project.

$155 USD om 3 dager

5,0

(1 omtale)

3,8

@imRaziel

hi. i can write a python script for this. i have some questions. why you need a database for this? do you need to do anything more than just merge CSV files into one? can you give a minimal example of data files and how the resulting CSV file should look like?

$150 USD om 3 dager

5,0

(3 omtaler)

3,6

@dfpr

I own a Macbook Pro and have experience in databases administrations, programming and text processing on microsoft excel.

$30 USD om 1 dag

5,0

(5 omtaler)

3,4

@angnut

Hi, I can create a configurable software (for MACBOOK) using .net core. You can configurate the merge using the pivot columns for the 2 differents lists. The sw will produce the 1 csv. I am an italian developer. Have a nice day Angelo

$444 USD om 10 dager

5,0

(6 omtaler)

3,1

@tdteam

Hello, I'm coder, I have more than 8 year experience in html, css, jquery, php, mysql, wordpress,joomla,..... I do many import csv to db projects, I have read your requirement and understood what you need, it can be done in web app. please discuss, thank you!

$111 USD om 2 dager