Pushing data form EXCEL sheet to Database [Resolved]

Posted by Samanthajyesta under ASP.NET on 5/25/2010 | Views : 2837 | Status : [Member] | Replies : 4
Hi,
i've an excel sheet with the employee details like empno,empname,designation and so on.
my question is that , if any employee enters his details in the excel sheet and clicks on the update button,the values that can be entered should be updated to the database.
can anybody help to do this as early as possible.

http://www.dotnetfunda.com


Responses

Posted by: Vuyiswamb on: 5/26/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down

Resolved
Thats Better , look at the following ways
http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx

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

http://www.c-sharpcorner.com/uploadfile/dipalchoksi/exportaspnetdatagridtoexcel11222005041447am/exportaspnetdatagridtoexcel.aspx

Thank you for posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

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

Posted by: Vuyiswamb on: 5/26/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Well that's a Difficult one. I am not sure you will be able to do that. There should be something that will trigger SQL to do the Updates, the challenge here is that Sql will not know that there are changes, but if it was Access it was going to be easier. Now what you need to do is to think of a way to tell sql that there are updated. Mybe what you need to do is to monitor the file size, if it changes then run a code to update sql or if there are any changes on the File and call a function that will run a code.


Thank you for posting at Dotnetfunda
[Administrator]

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

Posted by: Samanthajyesta on: 5/26/2010 [Member] Starter

Up
0
Down
Hi sir,
my question is that,
How can we import data to database from an excel sheet.
and it can be done when we click on a button in aspx (design) page.

http://www.dotnetfunda.com

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

Posted by: Samanthajyesta on: 5/27/2010 [Member] Starter

Up
0
Down
Thank very much sir.
the links helped me complete my work.

http://www.dotnetfunda.com

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

Login to post response