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.
60 freelancers are bidding on average €481 for this job
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
--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
I have around 8 years of experience in sql development and MSBI technology. I will create a package for you import your data and export it using the select statement in desired format.