Saludos, estoy leyendo un archivo de excel y luego almacenando sus datos en una tabla en access como un medio de actualizacion en lote de la misma, pero me presenta el siguiente error:
Server Error in '/xyz' Application.
--------------------------------------------------------------------------------
Cannot create ActiveX component.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: Cannot create ActiveX component.
Source Error:
Line 38: Dim bod_dim As Integer
Line 39:
Line 40: appExcel = CreateObject("Excel.Application")
Line 41: Dim mstrRutaOrigen2 As String = Path.GetFullPath(FileUpload1.PostedFile.FileName.T oString)
Line 42: Dim bodega_libro As String = mstrRutaOrigen2
Source File: c:\inetpub\wwwroot\xyz\administracion\bod\default. aspx.vb Line: 40
Stack Trace:
[Exception: Cannot create ActiveX component.]
Microsoft.VisualBasic.Interaction.CreateObject(Str ing ProgId, String ServerName) +200
_administracion_bodegas_default.Button1_Click(Obje ct sender, EventArgs e) in c:\inetpub\wwwroot\xyz\administracion\bod\default. aspx.vb:40
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
Si alguien puede ayudarme, gracias!