急救！各位帮忙呀！！

[wubaiyong]

Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Excel Driver (*.xls)};"
DBPath = "DBQ=" & Server.MapPath( "upload/file0.xls" )

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

Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源，参数二为Connection对象

sql="Select * From [name&'"&i&"'$]" '错误地方
rs.Open sql, conn, 2, 2
如果SQL语句中含有变量这个SQL语句怎么写呀，谢谢！

[kickken]

这是我打开 excel 时用的看看行不行

Set Rs = Server.CreateObject("ADODB.RECORDSET")

strCn = "driver={microsoft excel driver (*.xls)}; dbq="& fileName

Rs.Open "Select * From ["&gfn&"$] ",strCn,3,1

[wei_gogo]

up