📄 100分求一个问题，关于asp操作excel的 .htm

📁 较为详细的介绍了asp自定义的各种函数,方便asp的各种开发.
💻 HTM
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0055)http://www.51base.com/article/view_article.asp?id=76201 -->
<HTML lang=zh-cn><HEAD><TITLE>NB联盟</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type><LINK 
href="NB联盟33.files/style.css" rel=stylesheet>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY><!-- start page body -->
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 class=td id=position 
width=773>
  <TBODY>
  <TR>
    <TD class=shadow colSpan=2 height=20 width=262>&nbsp;&nbsp;<A 
      href="http://www.51base.com/"><IMG border=0 
      src="NB联盟33.files/logo1.gif"></A> </TD>
    <TD align=right width=505>
      <P align=left></P></TD></TR></TBODY></TABLE>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 id=main width=770>
  <TBODY>
  <TR>
    <TD class=tdlbr vAlign=top>
      <TABLE align=center border=0 cellPadding=0 cellSpacing=0 id=welcome 
      style="TABLE-LAYOUT: fixed" width="98%">
        <TBODY>
        <TR>
          <TD style="TABLE-LAYOUT: fixed; WORD-BREAK: break-all" 
            vAlign=top><FONT color=red><B>文章标题</B></FONT><FONT color=red><B>: 
            100分求一个问题，关于ASP操作EXCEL的 </B></FONT>
            <HR noShade SIZE=1>
            <BR>&lt;% &nbsp;<BR>Set &nbsp;conn &nbsp;= 
            &nbsp;Server.CreateObject("ADODB.Connection") &nbsp;<BR>conn.Open 
            &nbsp;"Driver={Microsoft &nbsp;Excel &nbsp;Driver 
            &nbsp;(*.xls)};DBQ=" &nbsp;&amp; &nbsp;Server.MapPath("Sample.xls") 
            &nbsp;<BR>&nbsp;<BR>SQL1="select &nbsp;* &nbsp;from &nbsp;[sheet1$]" 
            &nbsp; &nbsp; &nbsp;<BR>Set &nbsp;rs &nbsp;= 
            &nbsp;Server.CreateObject("ADODB.Recordset") &nbsp;<BR>rs.Open 
            &nbsp; &nbsp;SQL1, &nbsp;conn, &nbsp;3, &nbsp;3 &nbsp;<BR>%&gt; 
            &nbsp;<BR>上面的SQL语句我想改成 &nbsp;<BR>Delete &nbsp;* &nbsp;From 
            &nbsp;[sheet1$] &nbsp;Where &nbsp;字段=Request(Form("name")) 
            &nbsp;<BR>这里的字段怎么写啊？ &nbsp;<BR>请帮帮忙！！！！ &nbsp;<BR>我的EXCEL的结构如下 
            &nbsp;<BR>A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; 
            &nbsp; &nbsp; &nbsp; &nbsp;C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
            &nbsp;…… &nbsp;<BR>姓名 &nbsp; &nbsp;住址 &nbsp; &nbsp; &nbsp;电话 &nbsp; 
            &nbsp; &nbsp; &nbsp;…… &nbsp;<BR>张三 &nbsp; &nbsp;南京市 &nbsp; 
            &nbsp;123456 &nbsp;<BR>…… &nbsp; &nbsp;…… &nbsp; &nbsp; &nbsp;…… 
            &nbsp;<BR>--------------------------------------------------------------- 
            &nbsp;<BR>&nbsp;<BR>字段要用中括号括起来： &nbsp;<BR>Delete &nbsp;* &nbsp;From 
            &nbsp;[sheet1$] &nbsp;Where &nbsp;[姓名]=Request(Form("name")) 
            &nbsp;<BR><BR></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><BR>
<TABLE align=center border=0 cellPadding=2 cellSpacing=0 id=footer width=770>
  <TBODY>
  <TR>
    <TD align=middle class=tdt>
      <P align=center></P></TD></TR></TBODY></TABLE><BR></BODY></HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -