How can I upload Excel sheet data into a database in asp.net?

Question

0.00/5 (No votes)

See more:

ASP.NET

Hi,

How can I upload Excel sheet data in to a database?

i need in asp.net not in VB

Posted 11-Aug-11 0:58am

Ashika s

Updated 15-Aug-11 18:14pm

v4

Add a Solution

Comments

Ashika s 12-Aug-11 5:05am

i need in asp.net .........niot in VB

Manfred Rudolf Bihy 12-Aug-11 11:18am

Edit your question using the link Improve question. Then add the tag VB.NET to your question.

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Herman<T>.Instance · Answer 1 · 2011-08-11T01:09:00

Solution 1

see http://forums.asp.net/t/1132513.aspx/1?How+to+upload+data+from+excel+to+Database[^] and pay attention to SqlBulkCopy command

more examples: http://weblogs.asp.net/rajbk/archive/2009/05/02/uploading-an-excel-file-to-sql-through-an-asp-net-webform.aspx[^]

google is so fine :D

Posted 11-Aug-11 1:09am

Herman<T>.Instance

Updated 11-Aug-11 1:10am

v2

reid0588 · Answer 2 · 2011-08-11T01:12:00

Solution 2

this is A BRILLIANT example..near enough does it for you

http://www.shiningstar.net/aspnet_articles/DataSet/DataSetProject.aspx[^]

Posted 11-Aug-11 1:12am

reid0588

koolprasad2003 · Answer 3 · 2011-08-11T22:43:00

Solution 3

Import Excel files to SQL Server dynamically[^]

Posted 11-Aug-11 22:43pm

koolprasad2003

Comments

Ashika s 12-Aug-11 4:53am

i need in asp.net .........niot in VB

How can I upload Excel sheet data into a database in asp.net?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How can I upload Excel sheet data into a database in asp.net?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us