OpenEuphoria

Re: ODBC - Excel Tables

• Posted by Matt Lewis <matthewwalkerlewis at gmail.c?m> Jul 10, 2007
• 610 views

Jonas Temple wrote:
> 
> Matt,
> 
> ODBC.e is getting a lot of attention right now!  I've also got a patched
> version
> that I'm going to be sending you soon.  I've added a columnList() function as
> well as expand the tableList() function to allow for more flexible table
> lists.
>  I also added handling of SQL_BIT and SQL_SMALLINT types and corrected handing
> of signed SQL_INTEGER types (it was only returning a positive numer and
> SQL_INTEGER
> can have negative values).

Cool.

> The reason I changed tableList() was I need to extract the tables from an
> Excel
> spreadsheet using the ODBC driver.  Excel tables show up as "SYSTEM TABLES"
> (at least the version I'm on) via another query tool that I use.  When I use
> ODBC.e and request all system tables from the Excel driver that points to my
> spreadsheet I get an empty result set.  
> 
> Have you ever used ODBC.e with Excel to get a table list?

No, I haven't.  When you say tables, do you mean the worksheets?  You might
try using EuCOM, which I have used with Excel.

Matt