Re: Get Excel work*** name(s) from spread*** using ODBC

Hello weboweb@xxxxxxxxxxx,
<weboweb@xxxxxxxxxxx> wrote:

w> Hello group,
w>
w>
w> I hope I've come to the right place to post my question!
w> I've tried many other groups with little luck...
w>
w>
w> I am trying to get the work*** names from an excel file using ODBC
w> (not excel automation), but for some reason I get SQL_NO_DATA error
w> code instead (100)
w> This code snippet I got from an example I found somewhere, and I
w> want to use this logic in a more complex program.
w>
w>
w> I'm hard-coding the file path for this example. This particular
w> spreadsheet contains 3 worksheets (Sheet1, Sheet2, Sheet3)
w> I've tried with many other spreadsheets but I can't seem to get the
w> work*** names. I've also tried the "SYSTEM TABLE" and "TABLE" in
w> the
w>
w>
w>
w> SQLTables called with no luck.
w>
w>
w> Would somebody please point me in the right direction as to what I'm
w> doing wrong here?

Google must have helped. The below is an excerpt from the old message:

IS> I tried to get list of *** names using SQLTables as described in
IS> MSDN but result set is empty.
IS> Can anybody help me with this?
IS>
IS> Source code:
IS>| ...snip...|
IS> rc = SQLTables(hstmt,0,0,0,0,0,0,(SQLCHAR*)"SYSTEM
IS> TABLE",SQL_NTS);

This is an old bug in the Excel driver. You are only given the possibility
of enumerating tables defined within worksheets, aka named regions,
by specifying "TABLE" as the table type.
--
Sincerely,
Dmitriy Ivanov
Common Lisp ODBC interface - www.ystok.ru


.