Closed

Application to sort and combine 2 data files

Hi there

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

1) results

2) test-all_OP

3) complete-results

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

Skills: C Programming, Microsoft Access, Software Architecture, Visual Basic, Windows Desktop

See more: sorted data, programming in excel 2013, programming excel spreadsheets, mdb files, excel to application, excel and access programming, excel access programming, sort excel, horse racing results, horse racing database, combine, combine excel, betfair data, excel breakdown spreadsheet, spreadsheet work breakdown, 2013 excel visual basic, file sort, excel 2013 visual, simple windows data application, excel horse racing database, excel spreadsheet horse racing, visual basic excel 2013, excel combine, horse racing data, horse results excel

About the Employer:
( 39 reviews ) United Kingdom

Project ID: #4335278

29 freelancers are bidding on average $130 for this job

Prashantskin

[url removed, login to view] I have gone through your project requirements. I will do all the things except the download of the data about the runner from internet. It can not be done via code. You will manually download it into an exc More

$150 USD in 3 days
(518 Reviews)
7.0
rhomeu

MS Access expert here. I can help you build the program to sort and combine your excel files.

$150 USD in 2 days
(41 Reviews)
6.5
jhaynes75

Professional software developer with over 13 years experience. Please see PM.

$150 USD in 5 days
(29 Reviews)
6.1
thelogicgates1

Hi, Ready to start. Check PMB please.

$235 USD in 15 days
(14 Reviews)
5.9
dobreiiita

Can I do this in JAVA?

$100 USD in 5 days
(65 Reviews)
5.4
expertcoder1vw

I'm an experienced database application developer with experience in developing data import applications with Excel / Access. I will add the import functionality to the Access database. I can do this job for you More

$210 USD in 2 days
(34 Reviews)
5.3
ZeusMan

Looking forward to working with you...

$100 USD in 2 days
(27 Reviews)
5.0
medsoftngo

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.

$100 USD in 5 days
(25 Reviews)
4.8
sanabaig

Lets Start

$100 USD in 1 day
(11 Reviews)
4.7
electrum2012

Hi Please see my private message for questions, clarifications and details of my experience and bid. Kind regards Reg

$250 USD in 10 days
(6 Reviews)
4.4
murtaza1981

Hi bluebelldatavw , I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write More

$350 USD in 10 days
(8 Reviews)
4.1
Pharoa

I have read your bid advert and attached document and understand your requirements. Based on this actuality, I am bidding to develop the software using Visual Basic 2010 in 10 days and to supply documented source co More

$200 USD in 10 days
(1 Review)
3.7
vicksan

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

$70 USD in 5 days
(3 Reviews)
3.4
developer0106

Hello, I have good hand on import utility and I would like to do it for you. Please check PM for more details. Thank you.

$80 USD in 3 days
(4 Reviews)
3.2
srdas2012

Hi,we are Expert in these Applications,See PMB

$92 USD in 2 days
(6 Reviews)
2.6
hexaguy

VB.NET programmer. ready to do this.

$35 USD in 5 days
(3 Reviews)
2.5
bubu77

Hi, Ms Access/Excel expert having 8+ years of IT experience. Can do it for you. Please see your PM for more details.

$120 USD in 2 days
(1 Review)
2.0
paolocarnelli

For more information please see the private message.

$240 USD in 5 days
(2 Reviews)
2.0
xeancaile

Consider it done.. please see PMB... regards..

$30 USD in 3 days
(3 Reviews)
1.3
PerfectInfo

Hi, Give this project to experts. We are having fifteen years of experience. We completely understand your requirement and will deliver assignment within given time [url removed, login to view] are ready to start immediatly. Please che More

$100 USD in 2 days
(0 Reviews)
1.6