This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
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