Re: ODBC - Excel Tables
- Posted by Jonas Temple <jtemple at ?hti.net> Jul 11, 2007
- 608 views
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