locked
Upload data from Excel to Database using C# RRS feed

  • Question

  • Hi,

    I want to develop application where user can upload excel data to SQL table.

    Here i want to validate data of excel, so that blank or any invalid character won't get uploaded.

    If any invalid data is there then i should intimate the user and upload remaining data.

    Please advise how can i write code for this...


    -- Kind Regards Sandeep

    Tuesday, June 4, 2013 11:54 AM

Answers

  • try http://stackoverflow.com/questions/15828/reading-excel-files-from-c-sharp


    its very good article on same with code.
    • Proposed as answer by A.Coder Tuesday, June 4, 2013 3:42 PM
    • Marked as answer by Sandeep.Handa Monday, June 10, 2013 2:30 PM
    Tuesday, June 4, 2013 3:19 PM

All replies

  • follow these articles

    http://forums.asp.net/t/1536177.aspx/1


    Thanks & Regards
    Syed Amjad Sr. Silverlight/WPF Developer,
    yahoo : syedamjad6736@yahoo.com, skype : syedamjad.0786.
    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, June 4, 2013 1:21 PM
  • try http://stackoverflow.com/questions/15828/reading-excel-files-from-c-sharp


    its very good article on same with code.
    • Proposed as answer by A.Coder Tuesday, June 4, 2013 3:42 PM
    • Marked as answer by Sandeep.Handa Monday, June 10, 2013 2:30 PM
    Tuesday, June 4, 2013 3:19 PM
  • Hi

    you can use OLEDB adapter to connect to EXcel

    Refer Article

    Tuesday, June 4, 2013 4:32 PM
  • Hi Sandeep,

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Thanks.


    Happy Coding!! If my post answers your question please 'Mark as Answer' and 'Vote as Helpful' if it helps you.

    Wednesday, June 5, 2013 8:26 AM