已完成

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!

技能: 数据库管理, 数据库开发, Excel, 微软Access

查看更多: 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

关于此雇主:
( 199个评论 ) New Orleans, United States

项目ID: #18507191

授予:

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 更多

$35 USD 在1天内
(4条评论)
3.1

39 威客就此工作平均出价 $38

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 更多

$25USD 在1天里
(180条评论)
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 更多

$35 USD 在30天内
(40条评论)
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 更多

$200 USD 在5天内
(46条评论)
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 更多

$25USD 在1天里
(69条评论)
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 更多

$30 USD 在2天内
(120条评论)
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 更多

$30USD 在1天里
(20条评论)
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. 更多

$20USD 在1天里
(55条评论)
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 更多

$25USD 在1天里
(50条评论)
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 更多

$150USD 在1天里
(27条评论)
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 更多

$25USD 在1天里
(15条评论)
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.

$50USD 在1天里
(10条评论)
3.6
sreenivas2903

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

$41 USD 在2天内
(6条评论)
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.

$30USD 在1天里
(2条评论)
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 更多

$50 USD 在2天内
(4条评论)
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 更多

$25USD 在1天里
(7条评论)
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.

$15USD 在1天里
(9条评论)
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 .

$25USD 在1天里
(3条评论)
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 更多

$25USD 在1天里
(1条评论)
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 更多

$100USD 在1天里
(2条评论)
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 & 更多

$20 USD 在0天内
(1条评论)
0.9