excel 连接 mysql_怎么才能用EXCEL去连接SQL 数据库读取数据!!!!

var conn;

function createconn(filename){

var tempresult = true;

connstr = baseconn+filename+";";

try{

conn = new ActiveXObject("ADODB.Connection");

conn.open(connstr);

//alert("打开数据库成功！");

}

catch(Exception)

{

tempresult=false;

}

return tempresult;

}

function genurls(conn){

var names,narray,i;

sql = "select userid from user";

var rs = new ActiveXObject("ADODB.RecordSet");

rs.open(sql,conn,1);

names="";

while (!rs.EOF){

if(names!=""){

names = names+" "+rs("userid").value;

}else{

names = rs("userid").value;

}

rs.moveNext();

}

取消

评论