Closed

Build a c# .net application to import CSV file into MSSQL Database

Need to create a c# .net library to import the CSV file into MSSQL Database (Multiple tables).

Requirements are below:

1) Read the CSV file ( and validate it for the standard sets of columns) . If validated then move to Step 2

2) First import the CSV file in a temporary table.

3) Once inserted in the temp table, compare it the Main Table - based on the some columns that I will provide once the project is confirmed. If match found then update the main table else insert it as new records.

4) In addition, need to match and update other child tables from the temp table.

Note: The flat csv file has approx 200 columns that needs to be inserted in 10-12 tables.

Only bid if you have done a similar project before or can show a working prototype.

Skills: C# Programming, .NET, Microsoft SQL Server, SQL, ASP.NET

See more: import csv file sql database express, import text file mssql dts, upload csv file save database php code, upload and read csv file in asp.net c#, how to read csv file in c# windows application, read data from csv file and store it in database c#, import csv file to oracle table c#, c# import csv file to datatable, c# create sql table from csv, import data from csv to sql server using c# in asp. net, read and write csv file in c#, script csv file sqlexpress database, import csv file sql database oscommerce, import csv file mssql asp, import excell file mssql 2005, import csv file mssql 2005 express, import csv file sql database asp net file uploader, import text file mssql express, loading csv file access database vb net, import csv file mysql database using codeigniter

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #21352716

66 freelancers are bidding on average $116 for this job

sumon355

Hello, As an experienced C# developer and having sound knowledge in importing data from CSV to mssql database, i am very much interested to do this project. Looking forward to have a positive response from you. Tha More

$200 CAD in 4 days
(328 Reviews)
7.7
customizedata

Have already worked on similar project that imports data to sql table fields from csv by following strict set of rules and validations.. I can share screen and demo.

$150 CAD in 7 days
(237 Reviews)
7.3
Agiletechstudio

Hi there, I read your initial requirements and I have some questions regarding your Build a c# .net application project. please send me a message so that we could discuss it further.

$50 CAD in 7 days
(72 Reviews)
6.8
rinsadsl

Hi There, I have already worked on similar tasks to read and import Excel,CSV in to MSSQL DB. Looking forward to discuss more in detail Thanks

$150 CAD in 3 days
(100 Reviews)
7.0
papon13

Greeting! My Name is Noor All Safaet and expert in Web Development. I would love to have the opportunity to discuss with you about your project. I have 5 years experience as a developer. Technical Summary 1. More

$150 CAD in 3 days
(144 Reviews)
6.6
khp31

Hi, I have done similer project recently. Lets discuss about it. I can finish your task. Thanks.

$250 CAD in 5 days
(51 Reviews)
6.5
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$150 CAD in 3 days
(15 Reviews)
5.7
vw6362291vw

Hello. I have some experience using Microsoft SQL Server integration with the .NET Framework common language runtime (CLR). All the actions you need will be carried out using a library written in c#.

$120 CAD in 7 days
(18 Reviews)
5.7
huangxiangyan

⭐How are you ?⭐ I have a detail look to your project, and I'm sure that I will complete your project surely. I am professional Software and website developer. My main skill is java, c#, c++, python, php and javascript. More

$150 CAD in 2 days
(18 Reviews)
5.7
mkmomy

Dear client, I read the requirements, I did the same task many times and I can develop solution for you. I have more than 9 years of experience in software development and web development using Microsoft technolog More

$120 CAD in 7 days
(60 Reviews)
5.7
KESHAVINFOTECH

Hi There, Thanks for your valuable time. :-) Please check below points : 1. Need to create a c# .net library to import the CSV file into MSSQL Database (Multiple tables). Requirements are below: 1) Read the More

$88 CAD in 10 days
(20 Reviews)
5.5
eramitjain9

Hi, I'm a .Net Professional with 10+ years of experience in Analysis / Design / Development with Distributed Web-Based, Client-Server Applications, based on different Solution Architectures using .NET Framework 4.0 More

$200 CAD in 5 days
(18 Reviews)
5.7
Victorier006

hello,how are you. i read your bid carefully. i am c#/.net expert and have full experience for 10 years. c#/.net language is my top skill. i can provide most quality and high speed. if you want to success, please cont More

$100 CAD in 7 days
(13 Reviews)
5.3
shobhitpundir

Hi There, Do we have the primary key (or columns to uniquely identifying record) so that records can be updated on main table? I believe in creating long relationships, trust and good communication. I usually reply w More

$200 CAD in 7 days
(15 Reviews)
5.1
dineshmore

Hi Myself expert in Dot net technologies with 14 yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. More

$250 CAD in 5 days
(30 Reviews)
5.4
AliSafder

Hi, My name is Ali and I can work on it with immediate availability. I can show you demo of Excel export to database. Let's have quick discussion so I can work on it.

$100 CAD in 5 days
(31 Reviews)
4.7
Wesleyvm

Hello, My name is Wesley and I have more than 12 years of experience in VB.NET; both in my professional life and for personal projects. The projects I like doing best is automating repetitive tasks. I have quite some More

$150 CAD in 4 days
(7 Reviews)
4.6
sapotacorp

Hi sir, We have read your project details and we are very much interested to work with you. Our latest ASP.NET projects are: [login to view URL], [login to view URL], moolahsense.com. I helped 9 clients from Canada then i t More

$102 CAD in 1 day
(11 Reviews)
4.3
sysdesigner13

Dear! I have read your project description and I'm very interested in your project. I have enough experience in c#. I can do this well as you want. Please send me a message so that we can discuss more details togethe More

$80 CAD in 7 days
(11 Reviews)
4.1
ahmmadalkhatib

I have been working as a full-stack developer for more than 9 years. I am detail-oriented and take good care to deliver a fully functional, fault-tolerant, and validated output within the specified time. This is a good More

$70 CAD in 7 days
(1 Review)
3.8