uploading .xlsx file into database table using asp.net and C#

Posted by Nagababu under Regular Expressions on 3/14/2011 | Points: 10 | Views : 13719 | Status : [Member] | Replies : 4
Hi All,


how to upload xlsx file's data to database with out saving it in the server.
Please let me know if there is a way to read the Excel stream and parse the data and send it to database
for storing in the respective table


Thanks,
Nagababu




Responses

Posted by: Vforvijay on: 3/14/2011 [Member] Starter | Points: 25

Up
0
Down
hi ...
If you want to upload xlsx file's just follow this linkl....

http://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html


Nagababu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 3/15/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

You no need to upload the excel sheet itself to the database instead the best approach can be like, read the excel sheet and from code behind copy the datas to the database table. To do that check the below link

http://www.codeproject.com/KB/database/Excel2Sql.aspx

Thanks
Karthik
www.f5Debug.net

Nagababu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Calinursu30 on: 12/13/2012 [Member] Starter | Points: 25

Up
0
Down
This import / export .NET library will do the trick
http://www.easyxls.com

Nagababu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Eva2012 on: 12/14/2012 [Member] Starter | Points: 25

Up
0
Down
You can see this article:
http://excelcsharp.blog.com/2012/10/29/export-excel-to-datatable-and-import-datatable-to-excel/


Nagababu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response