We help IT Professionals succeed at work.
Get Started

import excel without having ms office on production server

603 Views
Last Modified: 2013-11-25
hi all,
      i create a web site and deploy on production server.

production server configuration:
OS:server 2003 r2
.net framework 2.0
but no ms office.

In this web site functionality are:
1.import data from excel: is not working
2.nd export data from excel: is working

i have use Interop.Microsoft.Office.Interop.Excel.dll which is in bin folder and reference from this.

how can i import data from this file without having ms office on server.

below is error during read excel.

please give any idea.
thanks in advance.
sujan









Access to the path 'C:\Inetpub\wwwroot\CONTACMembership\ContactAdmin\import\JourneyClubMember.xls' is denied.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode)
   at System.Web.HttpPostedFile.SaveAs(String filename)
   at System.Web.UI.WebControls.FileUpload.SaveAs(String filename)
   at Admin_ImportExcelToDatabase.imgbtnimport_Click(Object sender, ImageClickEventArgs e)
11/06/2010 2:27:01 AM

Open in new window

Comment
Watch Question
Technical Analyst
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE