jdbc odbc Excel: loop thru all sheets.

Thread view:

natG - 23 May 2005 19:06 GMT

Using an Excel (latest) Workbook on WinXp, with many sheets as the DSN,
how do I get the jdbc odbc driver to loop thru all the sheets? In other
words, I want the sheet name, which jdbc sees as a table, to be a variable.

Also, can anyone explain the phenomenon; although I have but one DSN for
one workbook, MetaData.getCatalogs returns a ResultSet with ALL xls files
in the dir. But alas, even though I have the catalog, getTables (which
should return all sheets) does not work.

Thank you all;
-nat

Reply to this Message

Lee Fesperman - 23 May 2005 21:07 GMT

> Using an Excel (latest) Workbook on WinXp, with many sheets as the DSN,
> how do I get the jdbc odbc driver to loop thru all the sheets? In other
[quoted text clipped - 4 lines]
> in the dir. But alas, even though I have the catalog, getTables (which
> should return all sheets) does not work.

This is likely a weakness in the ODBC driver that you are using rather than the
JDBC:ODBC driver. Maybe you can find a better ODBC driver for Excel ... I wouldn't know.

Signature

Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

jdbc odbc Excel: loop thru all sheets.

Free Magazines