db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <de...@segel.com>
Subject RE: Import data into Derby
Date Thu, 16 Feb 2006 00:41:35 GMT

That's probably the best way.

The best way is to select the columns that you want and copy it in to a
second work sheet. Then save the worksheet as a csv (comma delimited

Then you just need to create a table that mimics it and load it in.

Note: The more columns you have, the greater the chance of munging something
up. By this I mean either forgetting a column or some other human error.

This is ok for a "one off".

You may want to consider looking at how to read a spreadsheet from Java and
pick and choose the fields then insert them. Too much work for a one off

(Yeah, I'm doing this too. ACT exported as a spreadsheet then morphed in to
a csv for uploading. Actually data split in to 3 files to make 3 tables....)


> -----Original Message-----
> From: Jeremy Foot [mailto:jeremy@thefeet.net]
> Sent: Wednesday, February 15, 2006 6:30 PM
> To: derby-user@db.apache.org
> Subject: Import data into Derby
> 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/

View raw message