Editor's review
This is a program for export of Access structures into Excel.
MultiLevelExporter is a Microsoft Access add-in. It enables exporting of Microsoft Access structures into Microsoft Excel and maintains Microsoft Access-like drill-down view. These include tables with Subdatasheet, Query with Subdatasheet, Form with Subdatasheet and Form with Subform. It is like the Access objects are being converted into Excel objects. Data from parental levels and corresponding children level are exported properly into Excel. For example, Datasheet or form will get transported along with Subdatasheets or Subforms. However, a maximum of seven nested levels can be accommodated. This is the limitation imposed by Access itself. When you need to share the data maintained in Access with other users who are not Access users or are not familiar with Access at all; this is a tool that will be useful. The ability to share data so that users need not learn about Access forms, queries and the whole Microsoft Access user interface is of great benefit often.
If you Access contains sensitive data that should not be shared, you could easily export and share only selected Tables, Queries or Forms and their children. The data shared could be further processed inside Excel while maintaining the parent-child hierarchy. You will be able to use non-Access features like Excel`s graphs, formatting, forms, formulas and other Microsoft Excel-specific features for further analysis. It is possible to get 1 to many data trees from non-Access database like the MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, SAP, dBASE, FoxPro, IBM DB2, LibreOffice Base, Informix, Teradata, etc. into Excel in addition. This is a very good tool.
User comments