求救:asp读取excel数据库时出错,请各路高手帮忙解决

2025-02-17 15:02:18
推荐回答(1个)
回答1:

set xlsconn = server.createobject("ADODB.Connection")
xlspath=request("refdata")
xlsconn.ConnectionString = "DBQ="+xlspath+";DRIVER={Microsoft Excel Driver (*.xls)};"
xlsconn.open
我估计是你的路径不对,你这样调试下:
set xlsconn = server.createobject("ADODB.Connection")
xlspath=request("refdata")
response.write(xlspath)
response.end
xlsconn.ConnectionString = "DBQ="+xlspath+";DRIVER={Microsoft Excel Driver (*.xls)};"
xlsconn.open