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 

More info at:

The other option is to to use some API like Apache Jakarta POI :


I have not used this, but a search on the web turned up some pointers:


Hope this helps.


View raw message