1. ODBC - Excel Tables
- Posted by Jonas Temple <jtemple at yhti.n?t>
Jul 10, 2007
-
Last edited Jul 11, 2007
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).
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?
Jonas Temple
http://www.innovativesys.net
2. Re: ODBC - Excel Tables
- Posted by Matt Lewis <matthewwalkerlewis at gmail.c?m>
Jul 10, 2007
-
Last edited Jul 11, 2007
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
3. Re: ODBC - Excel Tables
Matt Lewis wrote:
> > 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.
Yes, each sheet should be returned by requesting SYSTEM TABLES.
I didn't consider EuCom since I'm writing an app that converts ODBC compliant
databases to another DB platform and I want to be able to do Excel.
Jonas Temple
http://www.innovativesys.net
4. Re: ODBC - Excel Tables
I've not used odbc.e with excel, but it sounds interesting.
