Excel tables with ODBC
lazarus / 16-Databases

----------------------------------------------------------------------
bigeno · 2016-02-14 18:56

This is my last problem with ODBC, can't get list of Excel tables
(sheets) via ODBC.

FODBCConn.GetTableNames doesn't get me table names. Don't know any SQL
query to get tables list directly.
The only way is this : Code: Pascal  [Select][+][-]window.onload =
function(){var x1 = document.getElementById("main_content_section");
if (x1) { var x = document.getElementsByClassName("geshi");for (var i
= 0; i FSQLquery.SetSchemaInfo(stColumns,'%','')but I get table:
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE
c:\example.xls Sheet1$ text 12
....

but its read whole xls file (all data). It must be simpler way. Pls
help guys.