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

Habilidades: Programação C, Microsoft Access, Arquitetura de software, Visual Basic, Área de trabalho do Windows

Veja mais: 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

Acerca do Empregador:
( 39 comentários ) United Kingdom

ID do Projeto: #4335278

29 freelancers estão ofertando em média $130 para esse trabalho


[login to view URL] 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 Mais

$150 USD in 3 dias
(518 Comentários)

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

$150 USD in 2 dias
(41 Comentários)

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

$150 USD in 5 dias
(29 Comentários)

Hi, Ready to start. Check PMB please.

$235 USD in 15 dias
(14 Comentários)

Can I do this in JAVA?

$100 USD in 5 dias
(65 Comentários)

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 Mais

$210 USD in 2 dias
(34 Comentários)

Looking forward to working with you...

$100 USD in 2 dias
(27 Comentários)

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 dias
(25 Comentários)

Lets Start

$100 USD em 1 dia
(11 Comentários)

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

$250 USD in 10 dias
(6 Comentários)

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 Mais

$350 USD in 10 dias
(8 Comentários)

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 Mais

$200 USD in 10 dias
(1 Comentário)

HI, I have experience with this type of app. [login to view URL] Above link shows a app created by me which does a similar thing with excel sheets. -regards

$70 USD in 5 dias
(3 Comentários)

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 dias
(4 Comentários)

Hi,we are Expert in these Applications,See PMB

$92 USD in 2 dias
(6 Comentários)

VB.NET programmer. ready to do this.

$35 USD in 5 dias
(3 Comentários)

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 dias
(1 Comentário)

For more information please see the private message.

$240 USD in 5 dias
(2 Comentários)

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

$30 USD in 3 dias
(3 Comentários)

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 [login to view URL] are ready to start immediatly. Please che Mais

$100 USD in 2 dias
(0 Comentários)