Import Excel Data to SQL Server in ASP.NET

Sign in to leave a comment.

• RS

  Rashi Sharma9y agoPosted Jun 21, 2017, 5:37 AM

  I tried the same but getting error - External table is not in the expected format.
  • RS

    Rushabh Shah7y agoPosted Oct 26, 2018, 1:34 AM

    Try to get the same file from a different location and not where the server stores it.
• 

  veera muthu9y agoPosted Feb 8, 2017, 5:43 AM

  Its very good. but i need to create windows forms application... please help as soon as possible..
• 

  Mufid Bagdadi10y agoPosted May 2, 2016, 2:52 AM

  Could not find a part of the path 'C:\Users\DESPOT\Documents\Visual Studio 2010\WebSites\importData\Files\detailsBook.xlsx'.
• HO

  Hamse osman10y agoPosted Jan 4, 2016, 3:54 AM

  how to delete the file after file upload
• 

  Ekrem Tapan11y agoPosted Oct 27, 2015, 4:19 AM

  good article
• 

  Sujeet Suman11y agoPosted Sep 29, 2015, 12:44 PM

  Good Article
• MS

  maddy s11y agoPosted Jun 30, 2015, 10:50 AM

  can we transform columns into rows by using unpivot or cross apply or outer apply in select query which written in the program?
• 

  Saber Shaikh11y agoPosted Mar 23, 2015, 1:24 AM

  nice
• ZA

  Zahid Ali12y agoPosted Oct 30, 2014, 7:02 PM

  Wow Great But I Have Question How Can We Connect Sql server To Software ..
• 

  Raushan Sinha12y agoPosted Sep 25, 2014, 8:13 AM

  i am trying to create a webpage which has option to browse an excel file and upload it to the database. but if i make some changes to the same excel and then upload it again. it should update the existing data in the database. but what actually happens that it gets re inserted
  • 

    Gaurav Gupta12y agoPosted Sep 26, 2014, 2:12 AM

    You should deleted existing data or make a backup of existing data in some other table and inserted new excel data in table.
• SB

  sanjay bhansali12y agoPosted Apr 10, 2014, 1:43 PM

  we can fatch data from excel using Microsoft.Office.Interop.Excel library. check this article http://dreamit-sanjay.blogspot.in/2013/06/import-data-from-excel-c-code.html:Microsoft.Office.Interop.Excel
• 

  Deepak Porwal13y agoPosted Oct 28, 2013, 8:15 AM

  When I uploaded it on my server the file got uploaded but it is not importing excel data to sql server. kindly help me
• NT

  Nutan Tripathi13y agoPosted Apr 22, 2013, 10:29 PM

  Above mentioned code is really very useful
• NT

  Nutan Tripathi13y agoPosted Apr 22, 2013, 10:29 PM

  with bulk upload i want to do huge calculation in backend in same process plz suggest
• AP

  Abhay Patil13y agoPosted Feb 6, 2013, 5:16 AM

  Nice article its working fine on local , but when I uploaded it on my server the file got uploaded but it is not importing excel data to sql server. kindly help me
• AP

  Abhay Patil13y agoPosted Feb 6, 2013, 5:12 AM

  Nice article its working fine , but when I uploaded it on my server the file got uploaded but it is not importing excel data to sql server. kindly help me
• AR

  ashu rawat13y agoPosted Jan 30, 2013, 7:01 AM

  hey its working....but its excuting d code two time...send d reason as soon as possible please...
• JC

  jishnu chandran13y agoeditedPosted Dec 25, 2012, 1:30 PMEdited Dec 25, 2012, 8:54 PM

  hi friend nice work .... keep it up.....
• AJ

  a jiaxi13y agoPosted Nov 23, 2012, 7:51 AM

  ??
• 

  Priya14y agoPosted Oct 23, 2012, 12:06 AM

  Nice article Gaurav....