Pushing data form EXCEL sheet to Database [Resolved]

Posted by Samanthajyesta under ASP.NET on 5/25/2010 | Views : 4243 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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

0	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

0	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

Latest Posts