倒霉的该死的aspsmartupload,竟然连官网都没有了。可是更倒霉的是竟然还要用它来实现上传excel后汇入数据到SQL server。太辛苦了,所以一定要把辛苦的历程记录下来。
先贴代码:
A.asp
function uploadDailySchedule()
{
//开始打开对话框上传文件[选择excel文件,后面要汇入]
if (showModalDialog('B.asp?Form_No=<%=Request("Form_No")%>',window,'resizable:yes;status:no;dialogWidth:400px;dialogHeight:150px')=="R")
{
//从Exce汇入到SQL Server
strurl="D.asp?Form_No=<%=Request("Form_No")%>";
var objXmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
objXmlHttp.Open("POST", strurl,false);
objXmlHttp.Send();
saveForm_Locale();//any fuction here
}
}
B.asp
<%@CODEPAGE=65001%><%Response.Charset="UTF-8"%>
<script type="text/javascript">
funct