SPREADSHEET-BASED RELATIONAL DATABASE INTERFACE

摘要

Multi-dimensional data in a relational database (12) is accessed via a conventional spreadsheet application program (10) such as MICROSOFT EXCEL© The database (12) can be accessed to either read information from the database (12) and write it directly into the spreadsheet (10), or read information from the spreadsheet (10) and write it directly into the database (12), i.e., without the data being stored in any intermediary data storage structure between the spreadsheet (10) and database (12), thereby enhancing operational speed. Predetermined metadata (20) is used to relate database organization to spreadsheet organization.