Congratulations to all monthly winners of May 2013 !!! They have won INR 2900 cash and INR 27497 worth prize.
DotNetFunda.Com Logo
Twitter TwitterLinkedIn
YouTubeGoogle
 Online : 16401 |  Welcome, Guest!   Register  Login
 Home > Forums > ASP.NET > How to Import Excel Sheet to SQL Server (all ms office versions) ...
Sankar20092010

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

Replies: 2 | Posted by: Sankar20092010 on 8/6/2012 | Category: ASP.NET Forums | Views: 344 | Status: [Member] | Points: 10  


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


Reply | Reply with attachment | Alert Moderator

 Responses below this adGet hundreds of .NET Tips and Tricks videos

 Replies

Megan00
Megan00  
Posted on: 8/6/2012 10:19:35 PM
Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator 

Ranjeet_8
Ranjeet_8  
Posted on: 8/7/2012 12:32:54 AM
Level: Gold | Status: [Member] | Points: 25

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

Reply - Please login to reply


Click here to login & reply

About Us | Contact Us | The Team | Advertise | Software Development | Write for us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 6/20/2013 2:41:54 AM