Upload data from excelsheet to SQL database

Question

1.00/5 (2 votes)

See more:

Hello Guys,

I have one project of client and client's requirement is that he want to upload data from Excel-sheet to Sql Database using web page in asp.net c#

I know simple how to upload data from Excel-sheet to Sql DB table but Question is that(?) - Suppose 1st time client upload 10 record from 1 sheet to Sql Db and 2nd time client and more 5 record in Excle-Sheet so total record is 15 and then client upload record then I have already 10 old record and this new 15 record upload then total 25 record inserting in Sql Db but I need to upload only last added 5 records only into Sql Db and also client made changes in 1st record then it also be updated in Sql DB.
So how it possible in best way for manage or sync Database

Technology : Asp.net 4.0/4.5, C#, Sql Server

Thanks...

What I have tried:

Hello Guys,

I have do simple upload data from Excel Sheet to Sql Database but every time I upload same Excel sheet data with addition and updation then effect should be done with exist data remain as it is in sql database and all excel data inserting as new entry so I want to as both updation and new addition should be perform.

Posted 20-Apr-16 23:54pm

JamesGill

Updated 21-Apr-16 4:08am

Add a Solution

Comments

Herman<T>.Instance 21-Apr-16 5:56am

Is Google banned in your country?

JamesGill 21-Apr-16 6:11am

No So, I can't use this community forum for any technology help

Herman<T>.Instance 21-Apr-16 6:18am

Have you checked all the given answers on this same question on CodeProject?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rkthiyagarajan · Answer 1 · 2016-04-21T00:09:00

Solution 1

Try this :-) Inserting Excel File Records Into SQL Server Database Using ASP.Net C#[^]

Posted 21-Apr-16 0:09am

rkthiyagarajan

Updated 21-Apr-16 2:30am

v2

AnvilRanger · Answer 2 · 2016-04-21T04:08:00

You have a couple of option if the client insist on having records that have already been uploaded in the sheet again.

1) The first is SQL Bulk Copy. I would not recommend this method for your requirements at all. What you could do is wipe out the data that is already upload and just use bulk copy to insert everything as new. The problem with this you can loose relationships with other tables. Again I would not recommend this at all.

2) You can loop through each line of the excel document and check if the row already exist in SQL and if so update the record if not insert the new record.