2017最新新闻事件今天:asp控制excel导入sql

来源:百度文库 编辑:神马品牌网 时间:2024/05/05 01:35:10
<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>

用行后提示
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'

OLE DB 提供程序 'microsoft.jet.oledb.4.0' 报错。提供程序未给出有关错误的任何信息。
不知道到底在哪出错了,很郁闷