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 : 1716 | Status : [Member] | Replies : 3
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




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response