ASP Y EXCEL

18/12/2007 - 06:15 por Franz | Informe spam
hola chicos mirentoy trantando de adjuntar un arcghivo excel mediante una
pagina .asp y no se por que no me sale esta codigo , me sale errores q no
puedo examinar , espero que me puedan ayudar les agredeceria



<%

Path=Server.MapPath("libro1.xls")

Set ConexionBD = Server.CreateObject("ADODB.Connection")

ConexionBD.Open "DRIVER={Microsoft Excel DRIVER (*.xls)};DBQ=" & Path

Set rsVac = Server.CreateObject("ADODB.Recordset")

rsVac.Open "Select * From A1:C3 ", ConexionBD,3,3

rsVac.MoveFirst

Response.Write "<table>"

Response.Write "<th>" & rsVac.Fields.Item(0).Name & "</th>" & vbCrLf

Response.Write "<th>" & rsVac.Fields.Item(1).Name & "</th>" & vbCrLf

Response.Write "<th>" & rsVac.Fields.Item(2).Name & "</th>" & vbCrLf

Set ConexionDBSql = Server.CreateObject("ADODB.Connection")

ConexionDBSql.Open "DRIVER={SQL
Server};Server=PCINF12;SOURCE=lista;UID=sa;PWD="

Set sql = Server.CreateObject("ADODB.command")

sql.ActiveConnection = ConexionDBSql

Do While Not rsVac.EOF

Response.Write "<tr>" & vbCrLf

'Response.Write "<td>" & rsVac(0) & "</td>"

'Response.Write "<td>" & rsVac(1) & "</td>"

'Response.Write "<td>" & rsVac(2) & "</td>"


sql.CommandText = "INSERT INTO
ConexionDBSql.relacion(nombre,direccion,correo) VALUES (" & rsVac(0) & "," &
rsVac(1) & "," & rsVac(2) & ")"

sql.execute

Response.Write "</tr>" & vbCrLf

rsVac.MoveNext

Loop

Response.Write "</table>"

ConexionBD.Close

ConexionDBSql.Close

Set ConexionBD = Nothing

Set ConexionDBSql = Nothing

%>
 

Leer las respuestas

#1 Daniel H. Villa
18/12/2007 - 18:37 | Informe spam
Hola Franz, no dices que error te esta dando.


"Franz" wrote in message
news:%
hola chicos mirentoy trantando de adjuntar un arcghivo excel mediante una
pagina .asp y no se por que no me sale esta codigo , me sale errores q no
puedo examinar , espero que me puedan ayudar les agredeceria



<%

Path=Server.MapPath("libro1.xls")

Set ConexionBD = Server.CreateObject("ADODB.Connection")

ConexionBD.Open "DRIVER={Microsoft Excel DRIVER (*.xls)};DBQ=" & Path

Set rsVac = Server.CreateObject("ADODB.Recordset")

rsVac.Open "Select * From A1:C3 ", ConexionBD,3,3

rsVac.MoveFirst

Response.Write "<table>"

Response.Write "<th>" & rsVac.Fields.Item(0).Name & "</th>" & vbCrLf

Response.Write "<th>" & rsVac.Fields.Item(1).Name & "</th>" & vbCrLf

Response.Write "<th>" & rsVac.Fields.Item(2).Name & "</th>" & vbCrLf

Set ConexionDBSql = Server.CreateObject("ADODB.Connection")

ConexionDBSql.Open "DRIVER={SQL
Server};Server=PCINF12;SOURCE=lista;UID=sa;PWD="

Set sql = Server.CreateObject("ADODB.command")

sql.ActiveConnection = ConexionDBSql

Do While Not rsVac.EOF

Response.Write "<tr>" & vbCrLf

'Response.Write "<td>" & rsVac(0) & "</td>"

'Response.Write "<td>" & rsVac(1) & "</td>"

'Response.Write "<td>" & rsVac(2) & "</td>"


sql.CommandText = "INSERT INTO
ConexionDBSql.relacion(nombre,direccion,correo) VALUES (" & rsVac(0) & ","
&
rsVac(1) & "," & rsVac(2) & ")"

sql.execute

Response.Write "</tr>" & vbCrLf

rsVac.MoveNext

Loop

Response.Write "</table>"

ConexionBD.Close

ConexionDBSql.Close

Set ConexionBD = Nothing

Set ConexionDBSql = Nothing

%>



Preguntas similares