File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Database Design Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Database Design" Watch "Database Design" New topic
Author

Database Design

Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
I have inherited an excel workbook which has been used as a database. I would like to get all the infomation inside a properly design schema with as little fuss as possible. However the data on the spreadsheets is laid out along two time axies one being time period 1980 - 2012 and the other being age 0 - 25. What is the best way of designing tables that take into account time series data and what is the easiest method of extracting data from excel into oracle ?
Regards
Nigel
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

I'd say the easiest is using SQL Loader. You can save your Excel spread sheet as a .csv comma seperated file, then you can load the data into any structure that you want. I wouldn't try to design the structure directly from the spreadsheet, but I would ask what is stored as data, what is the information about, what is needed, then design the data tables, then extract the data from the spreadsheet, and determine how to load the data.
But SQL Loader is the best route.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database Design