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

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

Latest Posts