我程序代码如下:
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 [三班$]"