How to structure a database created in Excel

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: