Moving-data-from-excel-to-sql-...

Question

0.00/5 (No votes)

See more:

Hi All,
Moving-data-from-excel-to-sql-server and the webservice

Please give me an advice for fulfilling the above task.which would be the proper way for achieving this task with minimal time delay.Can we achieve through Crystal report or SSIS tool or any other method?If it so, can we integrate with MVC4 application project?

Please advice me.

Thanks & Regards,
Soumya

Posted 29-Dec-14 2:43am

soumyaraj

Add a Solution

Comments

Maciej Los 29-Dec-14 8:49am

What kind of issue do you have? What you mean by " the proper way for achieving this task with minimal time delay"?

soumyaraj 29-Dec-14 10:28am

if you want to insert about 2000 rows from excel file, also at the same time need to fire a webserivce call and pass the parameter from each rows.Sure normal c# code will not have a proper solution.So we need to achieve with minimum time frame.

Maciej Los 29-Dec-14 11:23am

Why do you think that "c# code will not have a proper solution"?
It's quite fast with SqlBulkCopy method...

soumyaraj 30-Dec-14 2:15am

Thank you.It's quite fast with SqlBulkCopy method.But we are worried about the fact that,after inserting each rows in to Db,we need to fire a webserice call for each rows.How could it possible with out much delay?

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)

Yugan_SA · Answer 1 · 2014-12-29T02:47:00

Solution 1

You can use the SQL Import export Wizard
Here are a link on how to do it
http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/[^]

Posted 29-Dec-14 2:47am

Yugan_SA

Updated 29-Dec-14 2:48am

v2

Comments

Maciej Los 29-Dec-14 11:39am

Sorry, you're wrong. OP wants to do that programmatically, using c#.

Manoj Kumar Choubey · Answer 2 · 2014-12-29T04:25:00

Solution 2

You can use simple methods to copy data from excel sheet to sql server
by using OLEDB/ADODB connection with excel sheet and using any method of bulk insert , bulk copy etc. you can transfer your data to sql server db.
I am confuse in your question you are asking crystal report or ssis
Please elaborate more what do you want to do exactly.

Posted 29-Dec-14 4:25am

Manoj Kumar Choubey

Comments

soumyaraj 30-Dec-14 3:22am

Actually we want to register employees via bulk insert from excel file, besides for each entry we need a webserive call for passing relevant Employee information.

Manoj Kumar Choubey 30-Dec-14 4:28am

Its depend on your web service logic and you need to think logic for both side, web service and data import part.