No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Posted Topic
[code=ASP]<html> <title>CodeAve.com(Create Excel on Server)</title> <body bgcolor="#FFFFFF"> <% accessdb="a" cn="DRIVER=Microsoft Access Driver (*.mdb)};" cn=cn & "DBQ=" & server.mappath(accessdb) Set rs = Server.CreateObject("ADODB.Recordset") sql = "select id,empname,phone from empp" rs.Open sql,cn rs.MoveFirst file_being_created= "states.xls" set fso = createobject("scripting.filesystemobject") Set act = fso.CreateTextFile(server.mappath(file_being_created), true) act.WriteLine("<html><body>") act.WriteLine("<table border=""1"">") act.WriteLine("<tr>") act.WriteLine("<th nowrap>id</th>") act.WriteLine("<th nowrap>empname</th>") …
The End.