Printable View
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?
I'm not a database expert by any means, but excel is a spreadsheet and as far as I know it has no sql support. I know however that you can link your spreadsheet to a dataase using a ODBC bridge.
Dustin
I don't know too much about this but I do know you can interface Excell with SQL, I did it a long time ago
with VB. I do remember their was a similar problem because Excell changed the way you interface a little
with Office 97. And who knows maybe they changed it again with office 2000.