Excel con ASP
hice la siguiente funcion en asp:
Function ahorro(ref)
Dim con_aho, res_aho
Set con_aho = Server.CreateObject("ADODB.Connection")
con_aho.Open "DRIVER={Microsoft Excel Driver (*.xls)};DBQ= " & Server.MapPath("ahorro_aporte.xls")
Set res_aho = Server.CreateObject("ADODB.Recordset")
res_aho.open "Select * from A1:C80", con_aho,3,3
While Not res_aho.EOF
for i=0 to i=80
ahorro= "select C(i) from A1:C80 where A= ref "
next
Wend
res_aho.close
con_aho.close
End Function
y al probarala me muestra el siguiente error
paginMicrosoft OLE DB Provider for ODBC Drivers error \'80040e37\'
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object \'A1:C80\'. Make sure the object exists and that you spell its name and the path name correctly.
si alguien me puede ayudar se lo agradecería inmensamente.
PD: pueden escribime al correo-e: [email protected]
Function ahorro(ref)
Dim con_aho, res_aho
Set con_aho = Server.CreateObject("ADODB.Connection")
con_aho.Open "DRIVER={Microsoft Excel Driver (*.xls)};DBQ= " & Server.MapPath("ahorro_aporte.xls")
Set res_aho = Server.CreateObject("ADODB.Recordset")
res_aho.open "Select * from A1:C80", con_aho,3,3
While Not res_aho.EOF
for i=0 to i=80
ahorro= "select C(i) from A1:C80 where A= ref "
next
Wend
res_aho.close
con_aho.close
End Function
y al probarala me muestra el siguiente error
paginMicrosoft OLE DB Provider for ODBC Drivers error \'80040e37\'
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object \'A1:C80\'. Make sure the object exists and that you spell its name and the path name correctly.
si alguien me puede ayudar se lo agradecería inmensamente.
PD: pueden escribime al correo-e: [email protected]