How to Import Excel Sheet to SQL Server (all ms office versions)

Posted by Sankar20092010 under ASP.NET on 8/6/2012 | Points: 10 | Views : 1045 | Status : [Member] | Replies : 2
Hi.....

I want a generic function to import excel sheet data to a table in sql server 2005. I am using one table only but i want to import
MS Office 2010 excel file, ms office 2007 file, 2003 file. Kindly give connection strings of these and please tell me how to import using a asp.net form .


Thanks and Regards

Sankar




Responses

Posted by: Megan00 on: 8/6/2012 [Member] Starter | Points: 25

Up
0
Down
You can use a free source FreeData Export Component to help you:
http://www.e-iceblue.com/Introduce/free-dataexport-component.html



Never give up! Smile to the world!
http://excelcsharp.blog.com/

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

Posted by: Ranjeet_8 on: 8/7/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Refer this url
http://support.microsoft.com/kb/321686

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

Login to post response