先把数据导入sql server在从sql server 导出excel
var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async="false";
xmlDoc.load("f:/a.XML");
var myErr;
//查询节点
var parentNode = xmlDoc.selectNodes("//row");
//处理调用xml时错误信息
if (xmlDoc.parseError.errorCode !==0)
{
myErr=xmlDoc.parseError;
document.write("错误信息:" + myErr.reason);
}
//**************************
// 建立数据库连接
//**************************
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+"Password=; Initial Catalog=test");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from a";
rs.open(sql, conn,3,3);
//************************
//数据处理
//************************
for (var i=0;i<parentNode.length;i++)
{
rs.addnew;
var childNode=parentNode[i].childNodes;
for (var j=0;j<childNode.length;j++){
//if (rs(0).value=childNode[j].getAttribute("name"));
rs(j)=childNode[j].text;
}
rs.update;
}
rs.close();
rs=null;
conn.close();
conn=null;