D
Dave
I do not get an error, but I also do not get any data in the excel file. I
know it is connecting to the db
<!--#include file="../db.asp"-->
<%
Response.ContentType = "application/vnd.ms-excel"
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<%
OpenDatabase dbc
set objrs = server.createobject("ADODB.Recordset")
SQL = "select * from title"
Set objrs=dbc.execute(SQL)
%>
<TABLE BORDER=1>
<TR>
<%
For i = 0 to objrs.fields.count - 1
%>
<TD><% = objrs(i).name %></TD>
<% next %>
</TR>
<%
while not objrs.eof
%>
<TR>
<% For i = 0 to objrs.fields.count - 1
%>
<TD VALIGN=TOP><% = objrs(i) %></TD>
<% Next %>
</TR>
<%
objrs.MoveNext
wend
%>
<body>
</body>
</html>
know it is connecting to the db
<!--#include file="../db.asp"-->
<%
Response.ContentType = "application/vnd.ms-excel"
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<%
OpenDatabase dbc
set objrs = server.createobject("ADODB.Recordset")
SQL = "select * from title"
Set objrs=dbc.execute(SQL)
%>
<TABLE BORDER=1>
<TR>
<%
For i = 0 to objrs.fields.count - 1
%>
<TD><% = objrs(i).name %></TD>
<% next %>
</TR>
<%
while not objrs.eof
%>
<TR>
<% For i = 0 to objrs.fields.count - 1
%>
<TD VALIGN=TOP><% = objrs(i) %></TD>
<% Next %>
</TR>
<%
objrs.MoveNext
wend
%>
<body>
</body>
</html>