Meaningless Drivel is fun!*
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 Android Security Essentials Live Lessons this week in the Android 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: 17249
    
    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
 
Similar Threads
Uploading and downloading data from excel sheet
Bulk data processing on J2EE container
Why do I need SQL when I have Excel?
How to upload the Excel to Database
Junk values in Oracle 10g