Find Jobs
Hire Freelancers

Creating Large Database

$10-30 USD

Terminado
Publicado hace alrededor de 5 años

$10-30 USD

Pagado a la entrega
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!
ID del proyecto: 18507191

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 as a multi-sharded solution; although, I wouldn't expect the need of such complexity. I can experiment with a database to see if it will never exceed the data limits you expect. Also, I can make a simple GUI for you to interact with the database(s); if it's pretty basic I can probably do it for the quoted bid (we can discuss further). So, my bid is for creating the database, and putting the data in it, and possibly provide you with a simple GUI for data entry and querying, and you will also have a Management Studio provided, free, from Microsoft. I have over 15 years of C#.Net programming experience. I also have 7 years of experience with SQL Server database. Thanks for your consideration, Don
$35 USD en 1 día
5,0 (7 comentarios)
3,6
3,6
38 freelancers están ofertando un promedio de $39 USD por este trabajo
Avatar del usuario
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 possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$30 USD en 2 días
4,9 (179 comentarios)
6,7
6,7
Avatar del usuario
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/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$25 USD en 1 día
4,9 (182 comentarios)
6,6
6,6
Avatar del usuario
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 hour. I have 19 years experience in Access and Excel VBA and macro coding.  My expertise are Access and Excel databases and complex spreadsheets. I have taken all classes from 07 to 13 beginner to expert. I have built well over 300 databases including Healthcare,  production,  inventory,  and many other custom databases.  The last company (a major hospital- facilities maintenance company) I worked for, I developed a custom access program to complete, work orders, budgets, payroll,  HR, AP, supplies and many other functions to run the entire office. I recreated many excel sheets and localized them in access with a better user interface. I am currently Freelancing as a Microsoft Access Database Developer. I have worked as a freelancer since 2013. I started developing full time in 2016. I started creating custom databases in excel and access in 1996. My strengths are improving office systems, and running an upstanding office. I have created over 300 Custom Microsoft Access databases in 19 years.  If you agree that my skills would make me a strong addition to your team, please message me, so we can discuss your needs in more detail
$35 USD en 30 días
4,8 (44 comentarios)
6,6
6,6
Avatar del usuario
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 saved to separate CSV file. I recommend Microsoft SQL Server which is very powerful and able to handle any number of rows. Having 6+ year's experience, I have excellent expertise in designing and developing relational database using SQL. If you would like to work from anywhere in the world using the Internet we need the cloud based solution (MS SQL Server on Cloud) so we need to host your SQL database somewhere to make it online. There are many option to host a SQL database e.g. Microsoft Azure, Amazon Web Service(AWS), or you could have your on VPS or Virtual Server and also we can host the database on shared hosting. We can develop the database using Microsoft SQL server, MySQL, PostgreSQL etc... If you are working on a single Computer or In LAN then we can install the MS SQL Server on your local computer and create the database in it. I am highly qualified for this project and would love to speak with you further about taking this project on. I can assure you that if you work with me once, you will always work with me for these kind of projects. Thank you for taking the time to read my proposal. Best regards
$25 USD en 1 día
4,9 (70 comentarios)
6,0
6,0
Avatar del usuario
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 rows able to be imported, queried,exported to the database from CSV files. Pls note that all the CSV files need to have the same format. Bests, Steve
$200 USD en 5 días
5,0 (48 comentarios)
6,0
6,0
Avatar del usuario
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 database with other specified business intelligence searches and lookup integrations. I am smart enough to take your business requirements and create database schema to reflect the intent of your requirements. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/website-design/database-design-link-site/ • https://www.freelancer.com/jobs/project-15444898/ • https://www.freelancer.com/projects/mysql/review-database-model-for-survey/ • https://www.freelancer.com/projects/sql/human-resources-database-creation/ EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$30 USD en 1 día
4,8 (24 comentarios)
6,0
6,0
Avatar del usuario
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. I can connect a folder to power bi. when you put new files inside the folder that will be added to output data automatically. I am ready to start your project immediately, please send me a message to discuss further. Thanks.
$20 USD en 1 día
4,8 (82 comentarios)
6,1
6,1
Avatar del usuario
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 Ms Access front end and SQL Server back end. So you can decide which way is optimal for you. Regards, Zura
$25 USD en 1 día
4,6 (54 comentarios)
6,2
6,2
Avatar del usuario
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 best solution. Let's have a chat and I am ready start your project immediately. Thank you
$150 USD en 1 día
4,8 (31 comentarios)
5,3
5,3
Avatar del usuario
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 in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$25 USD en 1 día
5,0 (39 comentarios)
5,0
5,0
Avatar del usuario
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 your project. Thanks.
$25 USD en 1 día
4,8 (16 comentarios)
4,4
4,4
Avatar del usuario
Hi sir, i am romi, based in indonesia. i read your requirement, and i am fully understand about the job. lets have discussion if you available. i will enlight you about which way that need to take to handlr a million database best, romi
$15 USD en 1 día
5,0 (20 comentarios)
4,1
4,1
Avatar del usuario
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 en 1 día
4,9 (5 comentarios)
3,7
3,7
Avatar del usuario
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 en 1 día
4,8 (19 comentarios)
3,9
3,9
Avatar del usuario
Hi. Iwould recommend the database for u please let me know ur requirment so tht we can discuss
$41 USD en 2 días
4,8 (7 comentarios)
3,5
3,5
Avatar del usuario
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 en 1 día
4,8 (5 comentarios)
3,3
3,3
Avatar del usuario
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 the details from you. I suggest to you to have a simple database using either paradox with desktop application build by Delphi, or SQL database linked with Delphi application. Both options are available and easy to use, fast and effective in terms of cost. Please review my profile and see the feedback of my previous employers, you will know that my customer satisfaction is my top priority. Looking forward to hear from you. Thank you Waseem
$50 USD en 2 días
4,9 (6 comentarios)
3,4
3,4
Avatar del usuario
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 en 1 día
5,0 (10 comentarios)
3,0
3,0
Avatar del usuario
Hey I can give you single python script which will be able to extract data from csv and also import data from csv. For the database we can use Amazon Redshift which is used for big data. Or even Hadoop File System and HBase can be used. We can discuss more over this over chat. Thanks
$55 USD en 1 día
5,0 (1 comentario)
2,3
2,3
Avatar del usuario
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 expert in doing in database tasks, as I have experience of 4 years in Angular, MySql development and NoSql databases and ERP level projects, so I know how to handle complex database tasks. I also work on native mobile apps. I would like to do your job at lowest rate as I am new to upwork and wanted to do this job only for good reviews. I will only expecting rating from you. I can do this job very fast. You only pay when work is done or after first proof of concept. I gurantee you the full satisfaction and you will be happy with my work. I will be thankful to you, if you award this job to me. Will looking forward to work with you. As a gift I will give you 20% discount and any html site from themeforest for free of cost. Thanks & Regards Dhruv
$25 USD en 1 día
5,0 (1 comentario)
1,8
1,8

Sobre este cliente

Bandera de UNITED STATES
New Orleans, United States
5,0
201
Forma de pago verificada
Miembro desde feb 21, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.