MultiLevelExporter

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.

It is an add-in for Microsoft Access that enables exporting of following Microsoft Access structures into Microsoft Excel:
- Table with subdatasheet
- Query with subdatasheet
- Form in datasheet view with subdatasheet
- Form with subform
It may also said that it 'converts' above mentioned MS Access objects into MS Excel worksheets.
The result of such a conversion is that data from both parental level (Datasheet or Form itself) and all its children's levels (Subdatasheets or Subforms) get exported into MS Excel Worksheet while keeping the original Access-like drill-down view.
It is commonly being used when there is a need to:
* SHARE MS ACCESS DATA (DATASHEETS WITH SUBDATASHEETS OR FORMS WITH SUBFORMS) WITH NON-ACCESS USERS
You may need to distribute such data to people who aren't familiar with MS Access or don't have MS Access at all.

* PROTECT SENSITIVE ACCESS DATA
If your database contains sensitive data that you don't want to share, you may export and share only selected Tables, Queries or Forms and their children, and opt not not share remaining sensitive data.

* PROCESS MS ACCESS-ORIGINATING DATA IN MS EXCEL WHILE KEEPING PARENT-CHILD LAYOUT
After you export Access data organized in parent-child layout into MS Excel, you may further analyze and process them in MS Excel Worksheet in the ways that aren't available in MS Access (you may use MS Excel's graphs, formatting, forms, formulas and other MS Excel-specific features).

* PRINT OUT PARENT-CHILD TREE-LIKE STRUCTURE
It is not possible to print Datasheet with Subdatasheet or Form with Subform and the underlying data of both parent and children levels all at once directly from MS Access.
Nevertheless after you export parent-child tree-like organized data into MS Excel you may print it now from there easily.

* EXPORT 1:N DATA OF ANY NON-ACCESS DATABASE INTO EXCEL

* EXPORT DRILL-DOWN STRUCTURED DATA INTO VARIOUS OTHER FILE FORMATS

* SEND DATABASE DATA VIA EMAIL