By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,696 Members | 1,424 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,696 IT Pros & Developers. It's quick & easy.

ASP input and EXCEL

P: n/a
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="ServerRequest.asp" ACTION="ServerRequest.asp"
METHOD="POST" >
<TABLE>
<TR>

<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>1. Please Enter your
Name: </SPAN></TD></b>
<TD><B><B>
<input type="text" name="Respondent">
</B></B></TD>
</TR>
<TR>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>2. What Project is
this for?:</SPAN></TD></b>
<TD><B>
<input type="text" name="BusinessUnitSponser">
</B></TD>

</TABLE>
<TABLE>
<tr>
<TR>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>3. Please enter the
remote access applications needed for this VM Guest Servers:</SPAN></
TD></b>
<TD><B>
<BR>
<FORM NAME="multiselectform" METHOD="post" ACTION="multiselect.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>&nbsp;</TD>
<TD><SPAN class=StandardText><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">Windows XP Professional</option>

<option value="win2k3">Windows 2003 Standard</option>
<option value="win2k3web">Windows 2003 Web Server</option>
</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><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>&nbsp;</TD>
<TD><SPAN class=StandardText><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>&nbsp;</TD>
<TD><SPAN class=StandardText><b>7. Please enter the permissions that
is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=permissions rows=10 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><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">TEST (QA)</option>
<option value="DEV">DEVELOPMENT</option>
<option value="STG">STAGING</option>

</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>9. Please enter the Application/
Service Name that is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=Application rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>10. Please provide a Brief Description
for the use of the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=description rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>11. Please provide any platform
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=independency rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>12. Please provide any external
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=exdependency rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><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>

Mar 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
google this for information on asp and Excel:

asp excel database
"anon1m0us" <an*******@yahoo.comwrote in message news:11**********************@n76g2000hsh.googlegr oups.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="ServerRequest.asp" ACTION="ServerRequest.asp"
METHOD="POST" >
<TABLE>
<TR>

<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>1. Please Enter your
Name: </SPAN></TD></b>
<TD><B><B>
<input type="text" name="Respondent">
</B></B></TD>
</TR>
<TR>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>2. What Project is
this for?:</SPAN></TD></b>
<TD><B>
<input type="text" name="BusinessUnitSponser">
</B></TD>

</TABLE>
<TABLE>
<tr>
<TR>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>3. Please enter the
remote access applications needed for this VM Guest Servers:</SPAN></
TD></b>
<TD><B>
<BR>
<FORM NAME="multiselectform" METHOD="post" ACTION="multiselect.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>&nbsp;</TD>
<TD><SPAN class=StandardText><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">Windows XP Professional</option>

<option value="win2k3">Windows 2003 Standard</option>
<option value="win2k3web">Windows 2003 Web Server</option>
</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><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>&nbsp;</TD>
<TD><SPAN class=StandardText><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>&nbsp;</TD>
<TD><SPAN class=StandardText><b>7. Please enter the permissions that
is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=permissions rows=10 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><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">TEST (QA)</option>
<option value="DEV">DEVELOPMENT</option>
<option value="STG">STAGING</option>

</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>9. Please enter the Application/
Service Name that is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=Application rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>10. Please provide a Brief Description
for the use of the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=description rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>11. Please provide any platform
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=independency rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>12. Please provide any external
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=exdependency rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><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>

Mar 20 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.