Automate CSV Import
$30-250 USD
Kulipwa wakati wa kujifungua
Hello,
I receive six files daily data files via an automated download. These files are all CSV files. I'm interested in having a means to automate the import of these files into separate SQL tables, parsing the data and adding part of the file name to a field within the table. I'm also interested in this import creating a log of the time the file was imported as well as the name of the file imported.
The attached file shows the type of data contained in each file. However, many of the fields are not populated ever and always blank although there is a space for the null data.
Please let me know an approximate cost to set this up. I'm using Microsoft SQL Server, and linking to this data via Microsoft Access.
Kitambulisho cha Mradi: #16188651
Kuhusu mradi
54 wafanyakazi huru wanazabuni wastani wa $148 kwa kazi hii
I can provide you with a program which will automatically down and then import the csvs into sql server. This can be scheduled in windows task scheduler.
I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I have done similar tasks before. I can help you with you request right now.
Hi, I'm a senior Databases developer. I have read your project description and I'd like to help you design an app using Ms Access and VBA to automate the process of import. I have done many similar project for automat Zaidi
I understand your requirements and should be no problems, i make automated tools for almost anything but there is no attached file as mentioned, maybe by mistake, can you provide me with the attachment that you wer Zaidi
Hi, I can build for you a program to save the csv data into sql server tables and write a log file with the processed file details. Please contact me in the chat for more details and send me a sample csv files.
I am not a random bidder... I have 14+ years of exp with various project exposure.. could you please ping me if you are interested with the proposal and thank you..
Have big experience as Senior Database Developer/DBA. Expert in MS SQL. I Know well T-SQL, make queries of any complexity. Many time make stored procs for data load from different files, also from .csv.
Hi Greetings of the Day, I understood requirement, I am interested in this task, I am full time freelancer carrying 13 yrs of experience in Mobile development, Web and Windows development using ASP.Net, MVC, Zaidi
Hello, I have gone through your job description. Few question to ask kindly get back to me with an answer . Do you have any reference style ? What is your timeline ? Awaiting your response. Thanks Haseeb
I am Australian Business Analyst with 15 years professional experience building automation and reporting solutions with a SQL Server back-end and an Access front end. If it works for you, I would like to build the im Zaidi
Hi There, Read your project requirements. I am an expert in asp.net, mvc, angular js, extjs, I can play role of architect, manager/scrum master and also as an full stack developer including rest based webapi, sql, bu Zaidi