Automate CSV Import

Imefungwa Ilichapishwa Miaka 6 iliyopita Kulipwa wakati wa kujifungua
Imefungwa 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.

Microsoft Access Mtandao wa Microsoft SQL Software Architecture SQL

Kitambulisho cha Mradi: #16188651

Kuhusu mradi

54 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

54 wafanyakazi huru wanazabuni wastani wa $148 kwa kazi hii

gangabass

I can create Windows application that will automatically import your files into SQL database (including part of the file name to a field within the table). All I need to start is some sample data from you + your dat Zaidi

$120 USD kwa siku 2
(Maoni 355)
7.3
Gates777

Hello? I am very interesting in your project. I checked your details very carefully and understood all. I can do this in a short time with high quality. I am expert in php, c#, python, web automation, simulation, a Zaidi

$200 USD kwa siku 3
(Maoni 41)
6.2
novepi

Hello there, Your requirement is quite clear and straightforward to implement. I'm planning to use c# to create a simple program which may be run through Windows Task Scheduler at anytime you need. When run program Zaidi

$100 USD kwa siku 1
(Maoni 49)
6.2
DavidLindon

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.

$98 USD kwa siku 3
(Maoni 44)
6.4
SergioAlfaroV

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.

$120 USD kwa siku 0
(Maoni 24)
6.0
alaeddindhahri

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

$100 USD kwa siku 2
(Maoni 72)
5.9
shantanupython

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

$45 USD kwa siku 3
(Maoni 48)
5.4
solucionesnet

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.

$120 USD kwa siku 5
(Maoni 29)
5.4
frehmanpk

Respected Sir, My name is Farrukh Rehman and I am former Stone Edge Customer Support Member. I have done a lot of customizations, Automations, Multi Channel Integrations and Custom Report Development in Stone Edge and Zaidi

$222 USD kwa siku 3
(Maoni 24)
5.1
vmadhavan15

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..

$200 USD kwa siku 3
(Maoni 21)
4.8
rayyankabir

Hello, I can do this today. I have excellent depth on MS Access, SQL, VBA, and Excel

$100 USD kwa siku 1
(Maoni 21)
5.0
aaz256

Hello. Your task to create a CSV import automation is rather easy for me, so I can offer you to very quickly realize it as a small .net utility. I have a great 15 years experience in software development and MSSQL data Zaidi

$66 USD kwa siku 2
(Maoni 5)
4.5
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Zaidi

$155 USD kwa siku 3
(Maoni 18)
4.2
AndreyBarykin

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.

$100 USD kwa siku 1
(Maoni 4)
3.2
ranzhie07

hi bro I can do the job in just 1day or less

$111 USD kwa siku 1
(Maoni 5)
3.2
bnrajumnc

A proposal has not yet been provided

$222 USD kwa siku 15
(Maoni 9)
3.7
sahumk2000

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

$222 USD kwa siku 3
(Maoni 12)
3.9
haseebjanoo

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

$200 USD kwa siku 10
(Maoni 2)
5.2
katiewells3

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

$222 USD kwa siku 5
(Maoni 4)
2.2
aravindakumar100

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

$190 USD kwa siku 3
(Maoni 1)
2.4