Create database query

Cerrado Publicado hace 3 años Pagado a la entrega
Cerrado Pagado a la entrega

I do a bit of sports trading as a hobby, mainly on the horse racing markets. I maintain a database which I update daily that currently contains 400k+ records. Each morning I download a list of horses due to race that day and manually check them against the database. This is quite time-consuming.

What I require is some mechanism where the daily list of runners is queried against the database and a report generated as a separate file showing the headings of the database file. There can be multiple returns for a horse or none if the horse hasn't run previously.

Ideally, if not too complicated, it would be nice to have the database headings as selectable items in the query mechanism so that headings may be included or omitted as required. If it's not practical to include all headings I can reduce them to those that I feel are necessary.

I am attaching a sample file with two tabs showing samples the daily runner list and the database.

MySQL Programación de bases de datos SQL Arquitectura de software Excel VBA

Nº del proyecto: #25754039

Sobre el proyecto

47 propuestas Proyecto remoto Activo hace 3 años

47 freelancers están ofertando un promedio de €474 por este trabajo

asin1987

WILL DO THE JOB IN NO TIME. Dear Employer, I understand you need to compare the horses daily data with your Database and produce results. Please message me, I will do the job in no time. We can talk about price if ne Más

€500 EUR en 2 días
(223 comentarios)
8.1
sr33raj

Hello, I can develop a database oriented system for your horse race needs. Let me know when we can discuss. Thanks

€750 EUR en 20 días
(582 comentarios)
7.6
gopalvora

Hi i can work for Create database query i am expert at , SQL , Software Architecture , MySQL , Database Programming , Excel VBA So send me Private message at PMB so we can discuss more about it Thanks

€500 EUR en 7 días
(302 comentarios)
8.0
zekovicm

Hi there I also have lot of experience with scraping betting/sports data and storing that in the database and creating different queries from it. Please feel free to initiate the chat so that we can discuss further de Más

€450 EUR en 4 días
(51 comentarios)
7.1
pofilippov

Hello. I can do your project. About me: — 9+ year of experience. — Any tasks — Improve your ideas

€500 EUR en 8 días
(39 comentarios)
7.2
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully. I checked the attached workbook as well… I am proficient with Microsoft Exc Más

€500 EUR en 5 días
(96 comentarios)
6.7
mateenbhatti94

Dear sir I can create a button in excel which will get you result from using this mechanism. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, Más

€500 EUR en 2 días
(64 comentarios)
7.0
VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? Más

€300 EUR en 3 días
(93 comentarios)
6.3
tutulsoft

--20 Years Database Expert with Excel ----- I am very much interested to update your Excel system with full automated system to reduce manual work --we need discuss to start --thanks

€250 EUR en 7 días
(62 comentarios)
6.3
BitSDestiny

With my 12+ years of Software Development experience like to work on your project,Please see my reviews to consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF,Android Application,iOS Application, Vis Más

€250 EUR en 15 días
(47 comentarios)
5.9
Martin718

Thanks a lot for taking your valuable time to read my message. After browsing your job description, I am very interested in your project and I believe I’m qualified for the task. Regarding Database Query, I have +8 ye Más

€500 EUR en 7 días
(2 comentarios)
4.7
irfanui

Full Stack Engineer Hey everyone , I'm Mohammad Irfan , very hardworking and dedicated to my work. I always deliver what i promise to my clients. we done our work with a lot of proficiency , as well as at the accurate Más

€750 EUR en 7 días
(4 comentarios)
4.7
janelka1991

Hi, sir. I am a software developer with DB for 8 years. I can work by full time for your project and trying to satisfy the requirements. I want to keep a long-term relationship for customer so I want to give a nice r Más

€500 EUR en 7 días
(3 comentarios)
4.4
dat2na

Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have Más

€833 EUR en 2 días
(4 comentarios)
4.4
WizeDev

Hi sir, Thank you for reading my proposal. Yes I think I can automate this workflow for you. I'll scrape the data and save the result in sqlite local database then I compare the new data with the old and I produce a Más

€400 EUR en 7 días
(5 comentarios)
4.1
vinod00k

Ready to start the work on your requirement with immediate effact , we can discuss more over chat, thanks regards Arjun singh.

€300 EUR en 7 días
(4 comentarios)
3.7
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. I Más

€250 EUR en 1 día
(11 comentarios)
4.2
dionisiotumbaga

Hi. I have considerable expertise in the design and development of MS Access databases. I have read the project details and the attached sample excel file. I believe a user friendly MS Access database would be perfect Más

€250 EUR en 7 días
(7 comentarios)
3.7
aap31374

I have more then 15 years of experience in SQL Server databse design, modeling, development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performan Más

€444 EUR en 2 días
(6 comentarios)
3.3
pierrenortje

Hi, hope you're enjoying the summer in Ireland. I'm always keen working on projects that have to do with odds and statistics. This project seems simple enough and automating it will save you a lot of time. Can't imag Más

€400 EUR en 5 días
(2 comentarios)
3.0