Find Jobs
Hire Freelancers

Export data from Excell to Access via ASP

$30-40 USD

Concluído
Publicado há mais de 21 anos

$30-40 USD

Pago na entrega
We have an existing program that exports our race data to an Excel file. We have created a web site that is used to view the races results, but runs from an Access database. We need something to get the Excel Data into the Access database automatically via a web interface. I have a perl script that can FTP from a html page to a specified directory on our server. What I would like created is an ASP script that will read a directory on our server where the excel file was FTPed to and import that data into the Access database. After the existing FTP script is run I will have this new ASP page launched. There are two distinct types of files reconisable by their file name and when FTPed will also have the date appended to the file name. The only difference between the two files is the types of races, and the outputed excel file setup is slightly different. Basically, with both tables the first few rows within the excel file (1 to 4) have the race information (Date, place, competitors, etc) this information goes into one table "Venue" to generate the race and race key. The remaining rows (6 - ???) have the records (places, prize money, name of competitor etc.) this data is to go into another table "Placings" with the race key. The access database is already set up and remains in the same directory as the Excel files will go. We are using a commercial server for our web hosting so have limited access to register DLL's, however, our existing site is already runing OK with the Access database, we just need a way to get our outputed data files into it with out re-typing. The attached ZIP file has of copy of each of the two excel files and the database. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code which is well commented of all work done. 2) Complete ownership and distribution copyrights to all work purchased. ## Platform Windows NT Server ## Deadline information The file is needed as soon as possible.
ID do Projeto: 2878715

Sobre o projeto

4 propostas
Projeto remoto
Ativo há 22 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
See private message.
$34 USD em 14 dias
4,9 (14 avaliações)
4,0
4,0
4 freelancers estão ofertando em média $34 USD for esse trabalho
Avatar do Usuário
See private message.
$34 USD em 14 dias
5,0 (10 avaliações)
5,3
5,3
Avatar do Usuário
See private message.
$34 USD em 14 dias
4,6 (1 avaliação)
2,5
2,5
Avatar do Usuário
See private message.
$34 USD em 14 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Australia
5,0
26
Membro desde out. 22, 2002

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.