parsing Excel spreadsheets and workbooks

[Jeff Zucker]

Jeff Zucker wrote:

> print $dbh->selectrow_array("SELECT * FROM $named_range");


Oh, and BTW, the first row of the named range will be treated as the
list of column names so your querries don't have to be generic.  You
can, in fact use any SQL query supported by ODBC.  There are various
options for specifying or auto-generating the data types of the columns
and other features.  See

    http://www.able-consulting.com/ADO_Conn.htm#ODBCDriverForExcel

and

    http://msdn.microsoft.com/library/psdk/dasdk/odbc6ho3.htm


-- 
Jeff
TIMTOWTDI