ASP input and EXCEL

**Jon Paal [MSMD]** · Mar 20 '07, 07:55 PM

Re: ASP input and EXCEL

google this for information on asp and Excel:

asp excel database

"anon1m0us" <anon1m0us@yaho o.comwrote in message news:1174419211 .080300.186320@ n76g2000hsh.goo glegroups.com.. .

Hi;
I am waaayyy new at ASP so I am hopping someone can help me. I wrote
an ASP that accepts input from a user. I need the input saved in
different cells in an excel sheet. Everytime someone hits Submit, it
should go to a new row.
The code below shows how I want the form set up. I have no clude on
how to get the input and save it on a server's D:\Drive. ANy help is
greatly appreciated!!!!
>
>
<FORM NAME="ServerReq uest.asp" ACTION="ServerR equest.asp"
METHOD="POST" >
<TABLE>
<TR>
>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>1. Please Enter your
Name: </SPAN></TD></b>
<TD><B><B>
<input type="text" name="Responden t">
</B></B></TD>
</TR>
<TR>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>2. What Project is
this for?:</SPAN></TD></b>
<TD><B>
<input type="text" name="BusinessU nitSponser">
</B></TD>
>
</TABLE>
<TABLE>
<tr>
<TR>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>3. Please enter the
remote access applications needed for this VM Guest Servers:</SPAN></
TD></b>
<TD><B>
<BR>
<FORM NAME="multisele ctform" METHOD="post" ACTION="multise lect.asp">
<SELECT NAME="RAccess" MULTIPLE SIZE="3">
<OPTION VALUE="RDP">RDP </OPTION>
<OPTION VALUE="Timbuktu ">Timbuktu</OPTION>
<OPTION VALUE="Console" >Console</OPTION>
</SELECT>
<br>
</Table>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>4. Please select the Operating System
for this VM Guest Servers:</SPAN></TD></b>
<TD><B>
<BR>
>
<form action="">
<select name="OS">
<option value="Deafult" >Select One</option>
<option value="XP">Wind ows XP Professional</option>
>
<option value="win2k3"> Windows 2003 Standard</option>
<option value="win2k3we b">Windows 2003 Web Server</option>
</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>5. Please enter the amount of RAM is
required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TD><B><B>
<input type="text" name="RAM">
</B></B></TD>
>
>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>6. Please enter the amount of HardDisk
is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TD><B><B>
<input type="text" name="RAM">
</B></B></TD>
>
>
</TD></B>
</tr>
</tbody>
</TABLE>
>
>
</TABLE>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>7. Please enter the permissions that
is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD> </TD>
<TD colSpan=7>
<TEXTAREA name=permission s rows=10 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
>
>
>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>8. Please select the enviornment for
this VM Guest Servers:</SPAN></TD></b>
<TD><B>
<BR>
>
<form action="">
<select name="Enviorn">
<option value="Default" >Select One</option>
<option value="POC">POC </option>
<option value="TEST">TE ST (QA)</option>
<option value="DEV">DEV ELOPMENT</option>
<option value="STG">STA GING</option>
>
</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>9. Please enter the Application/
Service Name that is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD> </TD>
<TD colSpan=7>
<TEXTAREA name=Applicatio n rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>10. Please provide a Brief Description
for the use of the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD> </TD>
<TD colSpan=7>
<TEXTAREA name=descriptio n rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>11. Please provide any platform
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD> </TD>
<TD colSpan=7>
<TEXTAREA name=independen cy rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>12. Please provide any external
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD> </TD>
<TD colSpan=7>
<TEXTAREA name=exdependen cy rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
>
<BR>
<TABLE>
<TD> </TD>
<TD><SPAN class=StandardT ext><b>13. Please enter the length of time
that is required for the life of the Guest Servers: </SPAN></TD></
b><BR>
<TD><B>
<BR>
<TD><B><B>
<input type="text" name="LifeCycle ">
</B></B></TD>
</TABLE>
<BR><BR>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
>
</FORM>
>

ASP input and EXCEL

ASP input and EXCEL

Comment