Completed

Creating Large Database

We manage over 1 million rows of data in Excel, mostly csv files. I want to find a solution to have all data in one database and be able to extract data, by state mostly, that will be saved to separate csv file.

What software package, cloud based or other method would be best?

I need a solid recommendation. Please provide your advice.

I have used a script within Excel and it doesn't work. Plus Access has a limitation on rows of data... I have over 1.5 million rows. The solution should be not Excel or Access. Thanks!

Skills: Database Administration, Database Development, Excel, Microsoft Access

See more: populate mysql database with test data, data programming creating large training sets, how to create dummy database, creating training data, how to create training data set, ai training data, fill database with dummy data, how to create dataset, extract xml database php, extract details database yellowpages, extract image database php, extract online database, extract image database, extract mdb database, php state corresponding country selected database, urdu topics project work provide please, creating large test suite selenium, creating large images photoshop hoardings, provide letter recommendation eminent, provide letter recommendation eminent person resident

About the Employer:
( 199 reviews ) New Orleans, United States

Project ID: #18507191

Awarded to:

DataDKR

Hi. What about SQL Server Express, which is free and has free GUIs to manage and view? It does have a 10 GB limit per database. Additionally, if you need a more complex solution, you could create one database per state More

$35 USD in 1 day
(4 Reviews)
3.1

39 freelancers are bidding on average $38 for this job

avinav606lx

Hi there, You could SQL database to store and query big data and at the same time be able to make big queries either by using SQL server client or using python. I have developed more than 500 VBA macros for Windows More

$25 USD in 1 day
(180 Reviews)
6.6
workerbee1974

Good afternoon.  my name is Donna.  I have read your project description. I feel I am qualified to assist.  I think microsoft access would be a great solution. you will have to update your budget. my rate is 30.00 an More

$35 USD in 30 days
(40 Reviews)
6.5
expertcoder1vw

I can develop this as a Windows desktop application using C# and SQLite or MySQL database, and deliver in a week or less. I did this previously for 2 clients and they were very happy with the work - over 1 million r More

$200 USD in 5 days
(46 Reviews)
5.9
dipakmoliya

Hi there, I have read your project description and can see that you want to find a solution to have over 1 million rows of data in one database and be able to extract data, by state mostly, that will be sa More

$25 USD in 1 day
(69 Reviews)
6.0
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

$30 USD in 2 days
(120 Reviews)
6.2
fanninson45

INTRODUCTION I can see you are interested in building back-end database to replace the existing Excel. I can import your data into database as well as provide consulting service to transform your data into databas More

$30 USD in 1 day
(20 Reviews)
5.9
aimefx

Hi, I am an expert in Excel, Access, VBA, Mysql and Power bi. I suggest you to you use Power bi, as it is free software from Microsoft. You can combine hundreds of file into a single file in power bi data model. More

$20 USD in 1 day
(55 Reviews)
5.6
zu02

Hi If you have data less than 2GB then you can use Ms Access. I can build a friendly interface via Ms Access for that. If not then you have to use SQL Express (10gb opportunity)- it's also free. Also possible More

$25 USD in 1 day
(50 Reviews)
6.2
VBAautomation

Hi, MS Access database would be perfect for this. Why MS Access: 2 gb data storage. Faster performance create dynamic query to see or export filtered data into excel. I can fulfill your requirements and provide you More

$150 USD in 1 day
(27 Reviews)
5.1
Capitan0Trueno

I have just finished a very similar project. Opening and manipulating a csv file with 12 million records. The best way is with a VBA script. I can help you with that. MS Excel advanced expert. 30 years experience More

$25 USD in 1 day
(15 Reviews)
4.0
nbprince

Hey, you can use Azure or other hosting to save your all databases into one single database. Its easy work for me and ready to do it.

$50 USD in 1 day
(10 Reviews)
3.6
sreenivas2903

Hi. Iwould recommend the database for u please let me know ur requirment so tht we can discuss

$41 USD in 2 days
(6 Reviews)
3.5
vladishat

This problem my be solved with the help of R-script or any else. the files are putted in one folder, then the script read the list of filenames, then it loops reading the files and row binding them in one table.

$30 USD in 1 day
(2 Reviews)
2.9
WaseemSh

Hello, My name is Waseem, I'm expert in Delphi Application development and have more than 10 years experience in programming. I would like to help you in your project and I'm ready to start immediately after I get More

$50 USD in 2 days
(4 Reviews)
3.1
xinglong717

Hi. I have read your description and have interests in your project. I have some experience in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about More

$25 USD in 1 day
(7 Reviews)
3.2
Gkiprop

hello, i would suggest for you to use pivot tables since the data is in csv format. it will make it possible to filter data in to different states.

$15 USD in 1 day
(9 Reviews)
2.9
atulamol

Hello Sir, IN my team i have 8 yr+ Experience Excel, VBA, Micro Developer. he can develop a Micro for your task. i want your requirement in details. For more discussion feel free to chat .

$25 USD in 1 day
(3 Reviews)
2.3
dhruvgupta1992

Hi, please initiate chat. MongoDB or Sql which you like I have solution for both. Greeting for the day. I can deliver you this project with the best cost in the mention time or less. Let's Discuss. I am e More

$25 USD in 1 day
(1 Review)
1.8
FD4CAST

I saw the change to your project description. Based on what you have said, even though you have discounted Excel, I think you are incorrect in this assumption. Let me explain. Your data is in CSV files. You need to More

$100 USD in 1 day
(2 Reviews)
1.8
Monirulop

Hi there! I am really excited to do this job if possible. Just now I have seen your job offer & noticed that you are finding someone to create a database. I have read job description with love & more attentively & More

$20 USD in 0 days
(1 Review)
0.9