c# code for import and export excel to sql server

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/[^]

Permalink

Posted 28 Jun '12 - 4:11

Tim Corey65.7K

Edited 28 Jun '12 - 4:22

Comments

Ritu khatri - 30 Jun '12 - 1:33

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:20

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:51

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

Tim Corey - 1 Jul '12 - 17:33

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.

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[^]



Exporting Data to Excel

Exporting Data to Excel[^]

Thanks
Ashish

Permalink

Posted 28 Jun '12 - 4:13

AshishChaudha39K

0	Sergey Alexandrovich Kryukov	508
1	Arun Vasu	315
2	Maciej Los	218
3	OriginalGriff	205
4	Aarti Meswania	170

0	Sergey Alexandrovich Kryukov	9,670
1	OriginalGriff	7,409
2	CPallini	3,968
3	Rohan Leuva	3,352
4	Maciej Los	2,861

c# code for import and export excel to sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

		9,889,766 members (46,812 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Interested
Ignored

c# code for import and export excel to sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us