i'm getting an odbc error doing a select on an excel file using jdbc-odbc. the statement is a simple "select * from Sheet1", with the
excel file having a Sheet1 worksheet and some data. the error says: "The Microsoft Jet engine could not find the object "Sheet1"".
Is this because of a special syntax requirement for the excel odbc driver? i've successfully made a connection to the excel datasource, but
my select sql doesn't go through. can anyone shed light on this one?