HOW CAN I STORE EXCEL SHEET SHEET TO DATABASE IN C#

Question

0.00/5 (No votes)

See more:

i have 3 columns in database table1
i want to store the excel sheet into table 1 the excel sheet has 3 colmns also
how to do that

Posted 9-Dec-15 18:07pm

Member 11970398

Add a Solution

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)

Suvendu Shekhar Giri · Answer 1 · 2015-12-09T18:35:00

Solution 1

Have you tried to search this in Google[^]?
Check these articles-
Import Data from Excel File to Database Table in ASP.NET MVC 4[^]
Import Data From Excel File to Database Table in ASP.Net MVC 4[^]

Hope, it helps :)

Posted 9-Dec-15 18:35pm

Suvendu Shekhar Giri

Comments

Member 11970398 10-Dec-15 2:28am

here u have written

dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if it is sql server database then how to write this line
dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

Member 11970398 10-Dec-15 2:28am

OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
i use SqlConnection excelConnection = new SqlConnection (excelConnectionString);

Member 11970398 11-Dec-15 5:26am

public ActionResult Upload(HttpPostedFileBase uploadFile)
{
String strConnection = "Data Source=Server=BANKING1\\MSSQLSERVER1;initial catalog=Online; User ID=sa;Password=Aldd439";

//file upload path
string path = uploadFile.ToString();
//Create connection string to Excel work book
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;Persist Security Info=False";
//Create Connection to Excel work book
OleDbConnection excelConnection =new OleDbConnection(excelConnectionString);
//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand("Select [ID],[Name],[Designation] from [Sheet1$]",excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);
//Give your Destination table name
sqlBulk.DestinationTableName = "ALQuestion.QuestionMaster";
sqlBulk.WriteToServer(dReader);
excelConnection.Close();