locked
Excel Problem RRS feed

  • Question

  • User2123993916 posted

    Hi,

    I am using Interp.excel.dll to import the data and OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=3;\""); to export the data. But I am unable to do it.

    The same is working perfectly in 32bit server but it is not working in 64 bit server.

    I am using Windows 2003 standard x64 bit edition with sp2. I want IIS to run only in 64 bit mode. Is there any work around so that I can use the same.

    Thanks & Regards,

    news4naeem


    Tuesday, January 19, 2010 5:50 AM

All replies

  • User-1853252149 posted

    Don't mark your post as resolved if it isn't, otherwise nobody will answer.  Also, if you need help, you need to give a better description of the problem than "I am unable to do it."

    Jeff


    Tuesday, January 19, 2010 4:23 PM
  • User2123993916 posted

    Hey sorry. It was done by mistake and by leaving "I am unable to do it." phrase you can understand what I have posted.

    k anyways I will explain it once again.

    I am using Jet 4.0 OLEDB driver to export the data from DB to excel. The problem is Jet 4.0 driver is compatible with only 32 bit OS(If I am not wrong) but I am using 64 bit OS. I even installed the driver mentioned in the below link.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

    I have also registered the oledb dll in "common files" and "system32" folder but still I am getting the error. "Microsoft Jet 4.0 driver is not registered".

    However, I am able to run the same by enabling32bitapplication on 64 in IIS 6.0 but after I do that the whole application is running in 32bit mode (Even though the setup is compiled in 64bit mode). I want the application to run in 64 bit mode so that I can use the features of the 64bit processor.

    thnks & regards,

    news4naeem


     

    Wednesday, January 20, 2010 1:50 PM
  • User2123993916 posted

    Any replies plz...

    Wednesday, February 10, 2010 5:53 AM