Hi Jeremy,
I never tried exporting a complicated data from spreadsheet myself,
but if you can export the spread sheet you have into delimited text
file(for example CSV text file format) . you can use the derby import
procedures(SYSCS_UTIL.SYSCS_IMPORT_TABLE or
SYSCS_UTIL.SYSCS_IMPORT_DATA) to quickly import data into a Derby table.
More info can be found in the derby docs:
http://db.apache.org/derby/docs/10.1/tools/rtoolsimport57005.html
Thanks
-suresh
Jeremy Foot wrote:
I have been saddled with a monster spreadsheet that I need to sift some
data out of.
Can anyone suggest a good way of importing the data into a Derby table?
My plan is to suck the spreadsheet in as a single table and then
normalise it afterwards so I don't need to be wildly fancy about schema.
Thanks
Jezza
___________________________________________________________ NEW Yahoo!
Cars - sell your car and browse thousands of new and used cars online!
http://uk.cars.yahoo.com/
