Find Jobs
Hire Freelancers

Looking to Automate Process to Load Data into Database

$2-8 USD / hour

Fechado
Publicado há aproximadamente 10 anos

$2-8 USD / hour

This is a request to possibly have a process to automate Microsoft excel files (CSV Files). All the files are currently in the same structure in each sheet. There is currently request to load over 1000 excel files a day into a SQL server table. They all come in the same format. So I was hoping to see if anyone would be interested in knowing a process to automate loading the files into the database. This is not a big job, its just grabbing data from the csv files and putting them into a database. If interested please get in touch.
ID do Projeto: 5879919

Sobre o projeto

16 propostas
Projeto remoto
Ativo há 10 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
16 freelancers estão ofertando em média $12 USD/hora for esse trabalho
Avatar do Usuário
Hi, I have experience with data processing, include import and export from/to different formats and purposes. "This is not a big job" - this is not true !!!! When you get duplicates and you lost part of you information, or incoming .CSV for some reason start coming in different format, you will understand that this is "big job". I can tell you more for .CSV importing but this is not your problem - import problems should be resolved by developer who do your project. Thank you, Slavi.
$15 USD em 10 dias
5,0 (1 avaliação)
3,8
3,8
Avatar do Usuário
Hello, I can write your process in a few hours with all the specifications. Hoping to work for you soon. Sincerely yours Eric
$7 USD em 3 dias
5,0 (1 avaliação)
2,7
2,7
Avatar do Usuário
A proposal has not yet been provided
$55 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
i am ready to take this project you can contact me on nst2014 @live.com... i am very much intertsed to take this project..
$5 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
hello employer, I can do this. Consider me and get it done perfectly as well as quickly. Please come for the discussion. Thank you.
$15 USD em 28 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I shall be able to help you with this. Please open chat session in order to discuss the program preferences and other details.
$4 USD em 15 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I'm expert in export Microsoft excel files (CSV Files) to a Sql Server table using visual basic. I worked in a project that arrived excel files (csv format) and I had to import them in a Sql Server table with some logic. The files arrive 3 times a year, and there were more than 1000 files. If you could give me an example file and an accesso to your example table. I can do it. The I'll explain you how to do the same in a work environment. Regards, Cecilia S
$8 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi...I have a good experience with database programmig so I can do the work for you. For this senario you need an application that will allow you to chose the excel file and wil loop through cells in the file, and insert new rows with this data in the appropriate table in ur database. Hope u take my bid in consideration . Thank u
$5 USD em 15 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi I can build your importation project, it's a very common task to load excel data into a database. The project will be built on Delphi and will have the following capabilities: - Select the file to open - Select the worksheet - Select the first data row to import - Select the column number for each imported field Expected development time: 3 days. Regards, Rubén.
$8 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have previously built an automated solution using SQL Server 2005 Integration Services that - 1. imports any csv files located within a directory on a daily basis 2. moves files to a Success or Fail folder depending on outcome of the import 3. once all files have been processed, the successful files are moved to a zip file with a date/time stamp It would be a simple job to modify this to run on a more frequent schedule, import excel files and add email notifications for success/failure on a file-by-file basis or for each execution of the import process. In addition, I am located in the UK so will be available during normal business hours for any communications (email or phone). I hope to hear from you soon and look forward to having the opportunity of working with you.
$10 USD em 15 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Dear Sir, I am new for freelancer.com but having more than 10 years of experience in customized application. I am interested to do your job. Kindly give a chance to prove my self on this platform Thanks & Regards
$4 USD em 6 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
This is one of my BAU tasks in my regular job. So I believe I can provide a generic and efficient process to extract the data from excel to SQL db.
$8 USD em 15 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
Birmingham, United Kingdom
5,0
10
Método de pagamento verificado
Membro desde jan. 27, 2013

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.