关于EXCEL的操作问题。急!问题一解决就结贴!!!

我程序代码如下:

 1   
 2Dim conn   
 3Dim Drivers   
 4Dim rs   
 5Dim Sql   
 6Set conn=Server.CreateObject("ADODB.Connection")   
 7Drivers="Driver={Microsoft Excel Driver (*.xls)};"& _   
 8"DriverId=790;"& _   
 9"DBQ=e:\test\select\chengji.xls"   
10conn.Open Drivers   
11Set rs = Server.CreateObject("ADODB.Recordset")   
12Sql="select * from ["&三班&"$]"   
13rs.Open Sql,conn,2,2   
14  

---------------------------------------
运行出错提示:
Microsoft VBScript 编译器错误 错误 '800a0408'

无效字符

/select/excel.asp,行12

Sql="select * from ["&三班&"$]"
--------------------^
请问该如何解决呢?
---------------------------------------------------------------

SQL1="select * from [三班$]"

Published At
Categories with Web编程
comments powered by Disqus