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
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Norman, United States
15 years experience working with various databases such as Paradox, Access, Oracle, dBase, SQL Server, db2. Primarily have worked in the area of document imaging and image and data analysis in the financial and medical industry.
Experto en PL/SQL Firebird, VB6, .NET intermedio, VBA y Excel
New Delhi, India
We are best in website designing and software development from last ten years. A huge list of satisfied clients. We do ethical business and never compromise on quality. Please give us a chance and take out most from us.
Addis Ababa, Ethiopia
Customized Business and Software Solutions in education, Business and Hospitality. We develop and support the CampusManager(Tm) Software family or enterprise applications, FinancialWorld(Tm) Software family of applications and InsuranceWorks(Tm) Software. We develop with Visual Studio, Visual FoxPro and Oracle
12 years experience in VBA, VB, VB.NET, ASP.NET
Buckhurst Hill, United Kingdom
I hold MSc in Mathematics and specialise in its financial applications. I have worked for various financial services companies, both within the corporations and on a freelance basis. I am now turning towards online freelancing as this best suits my flexible working pattern needs.
Wilmington, United States
Over 15 years experience in programming.
## BIO I am a tech consultant with varied experience in development, designing, consulting more than 100 IT projects of varied sizes. Recent interest have been in API, IOT and solution consulting. ## Area of Expertise Hardware integration, Project understanding, c#, SQL, PHP, XAML, XML, SignalR etc.
I'm hard-working, dedicated and committed programmer. Provide support even the project is finished.