用纸包书皮的做法:asp控制excel

来源:百度文库 编辑:中科新闻网 时间:2024/05/06 13:09:13
<script language="javascript" runat="server">
var sDBserver = "test-server";
var sDB = "worktime";
var sDBusername = "sa";
var sDBpassword = "sa";

var sConnectionString = "Provider=SQLOLEDB;Data Source=" + sDBserver + "; Initial Catalog=" + sDB+"; User Id=" + sDBusername +"; password =" + sDBpassword;

function DataBase(){
this.Cnn=Server.CreateObject("ADODB.Connection");

this.Open=function(sConnectionString){
this.Cnn.open(sConnectionString);
}

this.Close=function(){
this.Cnn.close();
this.Cnn=null;
}

this.ExecSQL=function(Sql){
this.Cnn.Execute(Sql);
}
}

var a;
var ssql;
var rs;
var db;
a = Request("FileName");
db=new DataBase();
db.Open(sConnectionString);
//ssql="select * from usr";
rs="openrowset('microsoft.jet.oledb.4.0','excel 5.0;hdr=yes;database="+ a +"',Sheet1$)";
ssql="select * into testtable from "+rs;
//Response.write(ssql);
db.ExecSQL(ssql);
db.Close();
db=null;
</script>

运行把本地excel读入远程sql,可出现没有找到sheet1的错误
请指教

建议你去网上下下相关的教程看看,一般这个用的不是很多