Carol Gloyd wrote:
Hi,
I’m new to Derby and was wondering if there is any way to directly
import an Excel spreadsheet into a Derby table. If this isn’t
possible, is there a work-around?
Thanks!
The first thing that came to my mind was to export the Excel spreadsheet
as a CSV (Comma Separated) file and use the
Derby Import utilities to load it into the database table created
(manually).
More info at:
http://db.apache.org/derby/docs/10.1/tools/
The other option is to to use some API like Apache Jakarta POI :
http://jakarta.apache.org/poi/
I have not used this, but a search on the web turned up some pointers:
http://forum.java.sun.com/thread.jspa?threadID=445015&start=0
Hope this helps.
-Rajesh
