Import Multiple excel workbook sheets into Multiple respective database tables

Question

0.00/5 (No votes)

See more:

I have an issue regarding the excel upload,i need to Import 25 sheets of data(1 work book) into 25 respective database tables from .net web application to sql server database. Please help me to resolve

Posted 29-Dec-15 1:31am

venu.kandukury

Add a Solution

Comments

Saad Saadi 29-Dec-15 7:36am

there are excel plug-ins available in asp.net. Using that, you can retrieve the data from Excels and load in SQL Server using SQL namespace.

venu.kandukury 29-Dec-15 7:43am

Hi Saadi

Thanks for your reply very much.

But i need to import through the file upload button so i need to write code in that button event. So can u please share the code into that event so that i can resolve the issue asap.

ZurdoDev 29-Dec-15 9:10am

No, no one is going to give you all the code. Where exactly are you stuck?

Nathan Minier 29-Dec-15 7:51am

Without any context (such as the work you've already done) there's not terribly much anyone can do to help.

I can only suggest that you look at using OpenXML to parse it, and insert the parsed data as appropriate.
https://msdn.microsoft.com/en-us/library/office/gg575571.aspx

1 solution

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)

2irfanshaikh · Accepted Answer · 2015-12-29T10:04:00

Solution 1

This Link[^] will help you to get all the sheets from the excel and convert to DataSet.
this Link[^]. will help you in inserting values in database.

Please google before asking question.

Posted 29-Dec-15 10:04am

2irfanshaikh