String sql = "select * from [Employee$] where id=" + empid;以上是我在java中写的语句,可是在运行会出现以下异常,我的Employee.xls文件是存在的,而且JDBC:ODBC驱动也没问题,那位高手能帮帮忙诰诉我是为什么吗?先行谢过!!java.sql.SQLException: [Microsoft][ODBC Excel Driver] 'Employee$' 不是一个有效名称。请确认它不包含无效的字符或标点,且名称不太长。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at com.excel.TestExcel.getEmpInfo(TestExcel.java:61)
at com.excel.TestExcel.main(TestExcel.java:108)
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at com.excel.TestExcel.getEmpInfo(TestExcel.java:61)
at com.excel.TestExcel.main(TestExcel.java:108)
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html