📄 vb如何写sql server 2000数据导出到excel？.htm
字号:
<html>
<head>
<title id='title911-1'>VB如何写SQL SERVER 2000数据导出到EXCEL？SQL数据有100万条，按ID顺序导出到EXCEL，每个表65000条 > </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!-- 搜索引擎会搜索到的关键字，有助于提高搜索排名 20060315 在这里增加 -->
<meta name="Keywords" content="office,Access,开发版,下载,office,开发版,access,下载,破解">
<!-- 搜索引擎会搜索到的网站介绍 -->
<meta name="description" content="上海,Access,编程,上海OFFICE ACCESS开发技术网站">
<!-- 希望搜索引擎索引本页，并跟踪本页 -->
<meta name="ROBOTS" content="INDEX,FOLLOW">
<link id="RSSLink" title="RSS" type="application/rss+xml" rel="alternate" href="http://access911.net/rss.asp">
</link>
<script language="javascript">
function CaptureIt(flameobject)
{
//window.alert("关于此主题请参考："+"\n "+document.all("a_"+flameobject.id.substr(2)).innerText+"\n \n专题地址：\n "+document.all("a_"+flameobject.id.substr(2)).href+"\n \n专题号：\n "+flameobject.id.substr(2));
var strCap="关于此主题请参考："+"\n "+document.all("a_"+flameobject.id.substr(2)).innerText+"\n "+document.all("a_"+flameobject.id.substr(2)).href+"\n"
//window.alert(strCap);
window.clipboardData.setData("Text",strCap);
}
_UM = "";
function IfUtf8(C)
{var N = (document.charset=="utf-8")?1:0
if (N == C)return true
var u = k = document.location.href
if (u.indexOf("utf8=")<=0)
u += "&utf8=9";
u = u.replace(/(utf8=)\d/ig,"$1"+(N?"1":"0"))
if (u != k)
{window.location.replace(u)
var w = window.open("","","height=1,width=1,menubar=no,resizable=no,titlebar=no,scrollbars=no,status=no,toolbar=no,menubar=no,location=no");
w.close()
}
}
IfUtf8(0)
</script>
<link href="/template/MSNstyle/hotmail___9080000065.css" rel="stylesheet">
<!-- <SCRIPT language="JavaScript" src="/template/MSNstyle/helppane___9080000001F.js"></SCRIPT> -->
<script language="JavaScript" src="/template/MSNstyle/hotmail___90800000744.js"></script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//--></script>
</head>
<body bgcolor="#336699">
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr valign="top">
<td width="266">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td nowrap> <a class="F" href="http://access911.net">Access911.net</a>
</td>
<td><font class="G">|</font></td>
<td nowrap> <a class="F" href="http://access911.net/bbs">a9BBS</a>
</td>
<td><font class="G">|</font></td>
<td nowrap> <font class="g">OTaA System</font> </td>
</tr>
</table>
</td>
<td>
<!-- <form name="form1" method="post" action="/index.asp?board=11">
<font class="G"> 搜索文章：</font>
<input style="WIDTH:250px;HEIGHT:18px" type="text" name="keywords" size="7" title="默认情况下只按文章标题搜索，并且只显示前20个结果。如果要按内容或者关键字搜索请到[搜索]栏目详细搜索。"><input value="20" type="hidden" name="topn"><input value="1" type="hidden" name="stype">
<input type="submit" name="Submit" value="Access 文章快速搜索" title="默认情况下只按文章标题搜索，并且只显示前20个结果"></form> -->
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td><img height="5" src="/template/MSNstyle/spacer.gif" width="1"></td>
</tr>
<tr>
<td align="center" width="100%">
<!-- 这里可以放广告 -->
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2">
<img height="1" src="/template/MSNstyle/spacer.gif" width="779"></td>
</tr>
<tr>
<td>
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td background="/template/MSNstyle/tab.bg.dln.gif" rowspan="2">
<a href="http://access911.net/" target="_top">
<img height="35" alt="Access911欢迎您光临" src="/template/MSNstyle/CN_CN_118x35.gif" width="160" border="0"></a></td>
<td background="/template/MSNstyle/tab.bg.dln.gif" rowspan="2"> </td>
<td rowspan="2">
<img src="/template/MSNstyle/tab.slide.hm.li.gif"></td>
<td bgcolor="#336699" colspan="12" height="13"></td>
</tr>
<tr>
<td><img src="/template/MSNstyle/tab.separator.off.gif"></td>
<td nowrap background="/template/MSNstyle/tab.bg.on.gif">
<a class="E" tabindex="120" href="javascript:G('http://access911.net');">
主页</a> </td>
<td><img src="/template/MSNstyle/tab.separator.on.l.gif"></td>
<td nowrap background="/template/MSNstyle/tab.bg.off.gif">
<a class="E" tabindex="121" href="http://access911.net/csdn">上传</a>
</td>
<td><img src="/template/MSNstyle/tab.separator.off.gif"></td>
<td nowrap background="/template/MSNstyle/tab.bg.off.gif">
<a class="E" tabindex="123" href="/index.asp?uec=bg">繁體版</a>
</td>
<td><img src="/template/MSNstyle/tab.separator.off.gif"></td>
<td nowrap background="/template/MSNstyle/tab.bg.off.gif">
<a class="E" tabindex="123" href="http://bbs.access911.net">论坛</a>
</td>
<td><img src="/template/MSNstyle/tab.separator.end.gif"></td>
<td width="100%" background="/template/MSNstyle/tab.bg.sln.gif">
</td>
</tr>
</table>
</td>
<td valign="bottom">
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td background="/template/MSNstyle/tab.bg.sln.gif">
<img height="35" src="/template/MSNstyle/spacer.gif" width="1"></td>
<td nowrap align="right" background="/template/MSNstyle/tab.bg.sln.gif">
<a class="G" href="#" onclick="this.style.behavior="url(#default#homepage)";this.setHomePage("http://access911.net")" target="_self">
设为首页</a> <font class="G">|</font>
<a class="G" href="javascript:window.external.AddFavorite('http://access911.net','Access911.net--我们只谈Access')" target="_self" title="Access911.net--我们只谈Access">
加入收藏</a> </td>
</tr>
</table>
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr bgcolor="#4791c5">
<td colspan="3">
<img height="1" src="/template/MSNstyle/spacer.gif" width="779"></td>
</tr>
<tr bgcolor="#4791c5">
<td height="20">
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td valign="center" align="left" width="100%"><font class="G"><script language='javascript' src='/rewrite.asp?mode=dday'></script>
<script language="javascript" src="/ip.asp"></script>
</font></td>
</tr>
</table>
</td>
<td align="right" height="20">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td valign="center" align="right"><font class="G">你现在的位置：近日更新</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<iframe class="NN" id="Hfrm" src="about:blank"></iframe>
<table class="N" id="HMTB" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2">
<img height="1" src="/template/MSNstyle/spacer.gif" width="779"></td>
</tr>
<tr>
<td>
<table class="O" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td width="8">
<img height="1" src="/template/MSNstyle/spacer.gif" width="8"></td>
<td class="P" onmouseover="MO()" onclick="G('/index.asp?board=1')" onmouseout="MU()" nowrap title="首次见面请多多关照，本页介绍了本站创建的主旨以及站长介绍">
<img alt="" hspace="1" src="/template/MSNstyle/i.p.folder.gif" align="absMiddle" border="0">
<a href="/index.asp?board=1" title="首次见面请多多关照，本页介绍了本站创建的主旨以及站长介绍">
首页</a></td>
<td class="LL">|</td>
<td class="P" onmouseover="MO()" onclick="G('/index.asp?board=2')" onmouseout="MU()" nowrap title="本站最近更新一览">
<img alt="" hspace="1" src="/template/MSNstyle/whatsnew.gif" align="absMiddle" border="0">
<a href="/index.asp?board=2" title="本站最近更新一览">近日更新</a></td>
<td class="LL">|</td>
<td class="P" onmouseover="MO()" onclick="G('/index.asp?board=3')" onmouseout="MU()" nowrap title="Access代码及常用软件下载----费用全免">
<img alt="" hspace="1" src="/template/msnstyle/i.p.putinfolder.gif" align="absMiddle" border="0">
<a href="/index.asp?board=3" title="Access代码及常用软件下载----费用全免">下载</a></td>
<td class="LL">|</td>
<td class="P" id="JunkTD" onblur="MME(event, Junk);" onmouseover="MME(event, Junk);" onclick="MCH(event,Junk)" onmouseout="MME(event, Junk);" nowrap title="各类文章都已经分类，您可以快速查看">
<img alt="" hspace="1" src="/template/MSNstyle/article_icon.gif" align="absMiddle" border="0">
<a href="/index.asp?board=16" target="_self" title="各类文章都已经分类，您可以快速查看">
文章索引</a>
<img hspace="1" src="/template/MSNstyle/i.p.downarrow.gif" align="absMiddle" border="0"></td>
<td class="LL">|</td>
<td class="P" onmouseover="MO()" onclick="G('/index.asp?board=7')" onmouseout="MU()" nowrap title="站内文章搜索，仿真 Google 搜索，请多加利用">
<img alt="" hspace="1" src="/template/MSNstyle/i.p.search.gif" align="absMiddle" border="0">
<a href="/index.asp?board=7" title="站内文章搜索，仿真 Google 搜索，请多加利用">搜索</a></td>
<td class="LL">|</td>
<td class="P" onmouseover="MO()" onclick="G('/index.asp?board=19')" onmouseout="MU()" nowrap title="中英文术语对照查询">
<img alt="" hspace="1" src="/template/MSNstyle/i.p.edit.gif" align="absMiddle" border="0">
<a href="/index.asp?board=19" title="中英文术语对照查询">术语</a></td>
<td class="LL">|</td>
<td class="P" onmouseover="MO()" onclick="G('/index.asp?board=22')" onmouseout="MU()" nowrap title="承接各类中小型数据库工程">
<img alt="" hspace="1" src="/template/MSnstyle/i.p.cal.task.gif" align="absMiddle" border="0">
<a href="/index.asp?board=22" title="承接各类中小型数据库工程">承接工程</a></td>
<td class="LL">|</td>
<td width="100%"> </td>
</tr>
</table>
</td>
<td>
<table class="O" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td width="100%"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2">
<img height="1" src="/template/MSNstyle/spacer.gif" width="779"></td>
</tr>
</table>
<table class="U" id="JunkTable" onclick="MCH(event,Junk,true)" width="100">
<tr>
<td class="W" onmouseover="MO_D()" onclick="G('/index.asp?board=17&articletype=1')" title="有关表的所有操作" onmouseout="MU_D()"> <font color="#000075">表</font></td>
</tr>
<tr>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -