c# code for import and export excel to sql server

Question

0.00/5 (No votes)

See more:

I want c# code for import and export (excel to SQL server database), but I don't understand the code and connection sting, so please help me to understand the following code:

string excelConnectionString = @Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NEETIN-PC\\SQLEXPRESS; Initial Catalog=data;Integrated Security=True; Extended Properties=Microsoft Office Excel 2003;HDR=YES;

What do I write in Provider and Extended Properties?

Posted 28-Jun-12 4:06am

Ritu khatri

Updated 28-Jun-12 5:51am

Vitaly Tomilov

v3

Add a Solution

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)

Tim Corey · Answer 1 · 2012-06-28T04:11:00

Solution 1

Here are a couple articles that explains how to do all of this:

http://www.c-sharpcorner.com/uploadfile/ae35ca/read-and-write-excel-data-using-C-Sharp/[^]

Reading and Writing Excel using OLEDB[^]

As for your connection string question, use this site to help generate the correct connection string for your version of Excel:

http://www.connectionstrings.com/[^]

Posted 28-Jun-12 4:11am

Tim Corey

Updated 28-Jun-12 4:22am

v3

Comments

Ritu khatri 30-Jun-12 1:33am

i used this code and successfully it work but when i second time click the button then the data will fill second time i want that same data is not insert it will overwrite

Tim Corey 30-Jun-12 12:20pm

That means that you have a working solution for this question. Now you have a new issue - the logic of your application has not been properly designed. On your button click, you first need to verify if the data exists or not. If it exists, you should overwrite it. If not, you should insert it.

Ritu khatri 1-Jul-12 3:51am

Thanx for answer.... and for this what query i write ???

Tim Corey 1-Jul-12 17:33pm

I can't tell you what query to write. That will be up to you based upon your data and your environment. Download a couple examples and get them working. Then start modifying them for your own use.

AshishChaudha · Answer 2 · 2012-06-28T04:13:00

Solution 2

Please follow the links of running code..

Import Data from excel to SQL server using C# in ASP. NET

Import Data from excel to SQL server using C# in ASP. NET[^]

<br />
Exporting Data to Excel

Exporting Data to Excel[^]

Thanks
Ashish

Posted 28-Jun-12 4:13am

AshishChaudha