28,390
社区成员
发帖
与我相关
我的任务
分享
<%@ language="jscript"%>
<%
var connXls = Server.CreateObject("ADODB.Connection");
connXls.Open('Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="Excel 8.0";Data Source=' + Server.MapPath('/db/xls/excel.xls'));
var rsXls = connXls.Execute('SELECT * FROM [Sheet1$]');
while (!rsXls.EOF) {
Response.Write(rsXls("name").Value);
Response.Write(" - ");
Response.Write(rsXls('password').Value);
rsXls.MoveNext();
}
rsXls.Close();
connXls.Close();
connXls = rsXls = null;
%>
var sql = "INSERT INTO [tab] ([name],[password]) "
+ "SELECT [name],[password] "
+ "FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\"E:\\wwwroot\\db\\xls\\excel.xls\";Extended Properties=\"Excel 8.0\";Persist Security Info=False')...[Sheet1$]";
// 上面没有做好 " 转义
conn.Execute(sql);
var sql = "INSERT INTO [tab] ([name],[password]) "
+ "SELECT [name],[password] "
+ "FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="E:\\wwwroot\\db\\xls\\excel.xls";Extended Properties="Excel 8.0";Persist Security Info=False')...[Sheet1$]";
conn.Execute(sql);