Hola, tengo un fichero en asp con el siguiente codigo (indicado mas abajo).
Mi problema es que el fichero con extension xxx.xls tengo que ubicarlo en el directorio c:\inetpub\wwwroot\ , sin embargo en el panel de control de servidor web que tengo, no existe ningun directorio al respecto.
¿Que debo hacer? Perdon por el desconocimiento del tema
Aqui esta el codigo:
<%
'Ensure that this page is not cached.
Response.Expires = 0
%>
<HTML>
<HEAD>
<title> Here is the code for displaying an Excel spreadsheet in a Web Page </title>
</HEAD>
<BODY>
<!-- This is an HTML comment -->
<%
'Creates an instance of an Active Server Component
Set oConn = Server.CreateObject("ADODB.Connection")
'Connects to the Excel driver and the Excel spreadsheet
'in the directory where the spreadsheet was saved
strConn = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=C:\Inetpub\Wwwroot\ASPTOC.xls;"
'Opens the connection to the data store
oConn.Open strConn
'Selects the records from the Excel spreadsheet
'CellsToDisplay is the name that was defined in the Excel worksheet
strCmd = "SELECT * from CellsToDisplay"
Set oRS = Server.CreateObject("ADODB.Recordset")
'Opens the recordset
oRS.Open strCmd, oConn
'Prints the cells and rows in the table
Response.Write ("<table border=1><tr><td>")
'Gets records in spreadsheet as a string and prints them in the table
Response.Write oRS.GetString (, 10, "</tr><td>", "</td></tr><tr><td>", NBSPACE)
