[teiid-issues] [JBoss JIRA] (TEIID-965) Need Excel file importer / connector

[Ramesh Reddy (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12653504#comment-12653504 ] 

Ramesh Reddy commented on TEIID-965:
------------------------------------

I believe the query you used with (a) or (d) are correct ones, if you used the default sheet name. If you renamed the sheet name then the table name would different.

Use of (b) and (c) are not applicable as they are treating the EXCEL file as the text file, and the connection you created is with JDBC <-> ODBC bridge driver. Currently Excel files can not be read with text connectors, they are only accessed with JDBC ODBC bridge.
                
> Need Excel file importer / connector
> ------------------------------------
>
>                 Key: TEIID-965
>                 URL: https://issues.jboss.org/browse/TEIID-965
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>             Fix For: Open To Community
>
>
> Really need to add an Excel connector in SP1.  The easiest way to do this is probably with one of the open source JDBC drivers that work over Excel files.  
> Something like:
> https://xlsql.dev.java.net/ - Excel JDBC driver (GPL unfortunately, so we probably can't distribute the driver)
> http://www.andykhan.com/jexcelapi/ - Java Excel API (GPL too)
> http://xlsjdbc.sourceforge.net/ - LGPL (uses Apache POI), really cheesy and maybe not being updated
> http://jakarta.apache.org/poi/ - Excel API, event-based and not particularly friendly
> http://www.vistaportal.com/products/vistajdbc-QA.htm - commercial

--
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