none
Excel runtime for .net RRS feed

  • Question

  •  

    Hi,

           I'm Developing ASP.NET application which is importing data from Excel. It's working fine, but when its deployed in the server. It not recognize the xls file (Server there is no excel installed)

     

              Without installing the Excel in the Production Server is it possible to put runtime file  ??

    or  

    any other methods to read the excel file??

     

     

    Below is my Connection String. Thanks in Advance.

     

    Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

    "Data Source=file.xls;" & _

    "Extended Properties=""Excel 8.0;IMEX=1;HDR=No;"""

     

     

     

    Tuesday, January 29, 2008 5:23 AM

Answers

All replies

  • Not sure whether you need excel or access installed (I don't think so) but try this
    http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
    Cheers
    A
    Tuesday, January 29, 2008 8:37 AM
  • Pretty sure you don't need anything installed, and if you want office 2007 support try this
    http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
    Tuesday, January 29, 2008 8:43 AM
  • You definitely do NOT need to install Excel on a server to be able to work with Excel files using Jet. But Jet OLEDB is not installed by default, since it is not a part of MDAC for several years. You need to install it separately downloading latest Service Pack (which I believe is 8) for Jet from here

     

    http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=Jet&DisplayLang=en

     

    And keep in mind that installation is platform-dependant.

    Tuesday, January 29, 2008 11:22 AM
    Moderator
  • Could you indicate what the error message is and the line of code on which it occurs?

    Tuesday, January 29, 2008 12:40 PM
  •  

    Yes. After i installed the JET OLEDB its working fine. Cheers.
    Wednesday, January 30, 2008 5:35 AM