how can retrive data from excel sheet and save in database with help of Fileupload control

Posted by Bhuwan87rawat under ASP.NET on 9/1/2012 | Points: 10 | Views : 2504 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hello sir,
In my application i want to access data from excel sheet and save in data base with the Fileupload control.....
this is possible

Regard
Bhuwan

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Saratvaddilli on: 9/1/2012 [Member] [MVP] Bronze | Points: 25

0	Yes , i think it is possible first you upload your excel file to the server and then read data from excel file and save data in to the database. To read Excel file data and to save into database please refer below links http://support.microsoft.com/kb/321686 http://www.aspsnippets.com/post/2009/02/04/Read-Excel-using-ADONet.aspx Thanks and Regards V.SaratChand Show difficulties that how difficult you are Bhuwan87rawat, if this helps please login to Mark As Answer. \| Alert Moderator

Yes ,

i think it is possible first you upload your excel file to the server and then read data from excel file and save data in  to the database.

To read Excel file data and to save into database please refer below links

http://support.microsoft.com/kb/321686 

http://www.aspsnippets.com/post/2009/02/04/Read-Excel-using-ADONet.aspx

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

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

Posted by: Bhuwan87rawat on: 9/1/2012 [Member] Starter | Points: 25

0	how to access data from excelsheet to display in textbox in asp.net Bhuwan87rawat, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Deepraj on: 9/1/2012 [Member] Starter | Points: 25

0	Hello, I think it is not possible directly with FileUpload. We have to read 1)excel data to gridview 2)gridview to sql table see Article How to popluate data to the gridview from excel sheet by Sheo Narayan Then write each gridview column data into sql table by INSERT Command or something. Bhuwan87rawat, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts