[ https://issues.jboss.org/browse/TEIID-965?page=com.atlassian.jira.plugin.... ] Steven Hawkins commented on TEIID-965: -------------------------------------- Ripan non-quoted SQL identifiers are not allowed to have ":", so you need to issue your query with the table name quoted: select * from ExcelData."c:/abcd.Sheet1$" Which if you issue it from the sample command line client will need likely need to be escaped: "select * from ExcelData.\"c:/abcd.Sheet1$\"" Since this is the reported table name (presumably from the TABLES system table), this should work as expected with your JDBC-ODBC source. As Ramesh indicates, getTextFiles is a procedure for file sources (using the file translator with a file datasource) and is not applicable for a JDBC source unless there is a corresponding stored procedure. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira