db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Kartha <karth...@gmail.com>
Subject Re: Import data directly from Excel?
Date Thu, 30 Mar 2006 21:43:32 GMT
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




Mime
View raw message