Reading excel file using java

[Bharadwaj Adepu]

Am having an MS Excel file from which i have to read the data, i found the way by searching, i.e through JDBC.
Now my problem is my column name is a date and if i give a select statement like

String query = "Select 28-Feb-08 from [Sheet1$]" ;
ResultSet rs = stmnt.executeQuery( query );

this is giving me the error

java.sql.SQLException: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.

Please help me! how can a read the with the column cell being a Date feild.

[Rob Spoor]

You could try putting the date between [ and ]. That usually works with Microsoft products in combination with databases (SQL Server, Access, etc).

[Scott Selikoff]

Use a Prepared Statement! Then you never have to worry about date formatting. Although I am curious why you're selecting a value with date as the field name, wouldn't "SELECT * FROM ... WHERE date='28-Feb-2008'" be more appropriate?

[Paul Clapham]

If the column name is really a date cell, that probably isn't the column name. I suggest you use a "SELECT * FROM ..." query and use the ResultSetMetaData object to find out the actual column names.

[Bharadwaj Adepu]

Thanks Paul. Now the problem is solved!