File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Reading excel file using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Reading excel file using java" Watch "Reading excel file using java" New topic

Reading excel file using java

Bharadwaj Adepu
Ranch Hand

Joined: Dec 30, 2007
Posts: 99
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

this is giving me the error

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

SCJP 1.5
Rob Spoor

Joined: Oct 27, 2005
Posts: 20271

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

How To Ask Questions How To Answer Questions
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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?

[OCA 8 Book] [Blog]
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

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
Ranch Hand

Joined: Dec 30, 2007
Posts: 99
Thanks Paul. Now the problem is solved!
I agree. Here's the link:
subject: Reading excel file using java
It's not a secret anymore!