asp.net excel

Sign in to answer this question.

• SA

  sarra amin18y agoPosted Feb 29, 2008, 7:45 AM

  I am sorry ,but I m using   google but I have not found how to import excel data to sqlserver in asp.net I found only  en ado
  Thanks

  sorry
• DV

  dilipv vishwakarma18y agoPosted Feb 29, 2008, 5:08 AM

  hi there,
  First of all are you aware of Google OR not, atleast you need to search articles baesd on it. Just check out the given links as follows.
  

  1. http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q321686
  2. http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx
  3. http://www.c-sharpcorner.com/UploadFile/vandita/exceltoaccessinterop02242007093426AM/exceltoaccessinterop.aspx

  Hope this will help you.
  Thanks & Regards
  Dilipv
  Programmer
  SharePoint Consulting
• SA

  sarra amin18y agoPosted Feb 28, 2008, 5:10 AM

  thanks very much mr;

  sorry my english is bad !!

  so to import data to excel i must import it to datagrid or gridview and after to excel .

  im using your help and  i  import data from gridview to excel but now i have another problem

  how imprting data from excel to sqlserver using asp.net?

  thanks
• DV

  dilipv vishwakarma18y agoPosted Feb 28, 2008, 3:27 AM

  hi there,
  You can easily export data from sql server to excel sheet easily, there are several articles available you can do google. So, just checkout the given link as follows.
  
  

  1. http://www.codeproject.com/KB/aspnet/ExportClassLibrary.aspx
  2. http://www.c-sharpcorner.com/UploadFile/DipalChoksi/ExportASPNetDataGridToExcel11222005041447AM/ExportASPNetDataGridToExcel.aspx
     
     Hope this will help you.
     Thanks & Rgards
     Dilipv
     SharePoint Consulting