Question:
How can I structure a database created in Excel?
Answer:
If you want to use data in an Excel database with Oracle Power Objects,there is no need to create a separate database, because you can use ODBC toaccess the data in the Excel spreadsheet.
If you want to duplicate the Excel spreadsheet, you can create thestructures you need in a database through OPO. You can then create adatabase connection to the Excel database with an ODBC connection andcreate a simple OPO form that uses the connection.
After you have created a connection to the Excel spreadsheet, you can usethe techniques found in my book Mastering Oracle Power Objects toexport the data from the spreadsheet to a text file.
The final step is to use the techniques in the same chapter to import thetext data into the new spreadsheet.