Re: ODBC - Excel Tables

new topic     » goto parent     » topic index » view thread      » older message » newer message

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

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu