uploading excel data to sql server tables RRS feed

  • Question

  • User1427320044 posted
    Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>I am using sql server 2005 ,asp.net2.0 , C#.
    I want to upload data from excel to sql server tables. <o:p></o:p>
    In the end if all data uploded then delete all rows in excel else left only those row which are not uploded successfully with erorr description.<o:p></o:p><o:p> </o:p><o:p> </o:p>please suggest some idea.<o:p></o:p><o:p> </o:p>

    Please Help


    Monday, April 6, 2009 5:24 AM


  • User1682002595 posted


    You can use automation (i.e. you should add reference to Office Interop Assemblies and use Excel object model to operate with rows).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 6, 2009 11:25 AM