郁闷,崩溃,ASP+EXCEL快把我逼疯了.

[zhangningsheng]

ASP连接EXCEL

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" & server.mappath("hz.xls") & ""

Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "select * from [商品收发汇总表$]", Conn, 2, 3
%>

上面的代码运行没有任何错误

但是表是找到了([商品收发汇总表$]),但是字段在哪儿呢?
翻来覆去找不到.
郁闷啊!!!!!!!!

[lygwahaha]

用 Rs.Fields(0)

[online]

<%
' 建立Connection对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Excel Driver (*.xls)};"
DBPath = "DBQ=" & Server.MapPath( "Sample.xls" )

' 调用Open 方法连接数据库
conn.Open Driver & DBPath

Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源，参数二为Connection对象
rs.Open "Select * From [成绩单$]", conn, 2, 2
%>
Rs.Fields(0)