We would like a simple windows application developed that will take the data from 2 excel spreadsheets containing horse racing data and combine them into one access database.
Each spreadsheet contains mostly different information about each horse race of the day, some information is duplicated and this will need to be sorted and removed. The data must then be sorted so that each race has the correct information about each runner in one row and then this data is insterted into an access database file ( .mdb)
We would also like the betfair SP information that is freely available for each runner then added to the database as a final task.
The attached .zip file contains an example of how we want this to work in 3 excel files
files 1 and 2 are the source files to be sorted and combined together in complete-results. You will see I have used some crude methods in excel to make this manual process a little easier however and application that can perform all the tasks would be much more preferable.
The xip file also contains a breakdown of how this data needs to be sorted in a .txt file
29 freelancers are bidding on average $130 for this job
I've done many programs that use Betfair API and extract data about horse racing from different oodscomparision sites and create excel files. This is a typical job for me. I garantee a full satisfaction.
HI, I have experience with this type of app. [url removed, login to view] Above link shows a app created by me which does a similar thing with excel sheets. -regards