MLE tool exports and transforms MS Access Tables with Subdatasheets, Queries with Subdatasheets or Forms with Subforms into Microsoft Excel while the resulting datasheets keep the Microsoft Access-like drill-down design of original objects.
Version: 8.7With MLE (MultiLevelExporter) tool you can export and transform Microsoft Access Tables with Subdatasheets, Queries with Subdatasheets or Forms with Subforms including all its data into Microsoft Excel.
License: Free To Try $9.00
Operating System: Windows
The result is that the data of the Datasheet or Form and also all its children (Subdatasheets or Subforms) get exported into Excel while the resulting spreadsheet keeps the Microsoft Access-like drill-down design of the original objects.
It is being used to:
- Share MS Access data (including 1:N relations/structure) with non-Access users.
- Protect sensitive MS Access data.
If your database contains sensitive data that shouldn't be shared, with MLE you may export and share only selected Tables, Queries or Forms and their underlying children, and not the remaining sensitive data. * Process Microsoft Access-originating data in Excel while keeping parent-child layout.
After you export parent-child structured data from Microsoft Access into Excel, you may want to further analyze and process the data in Microsoft Excel Worksheet in the ways that aren't available to Microsoft Access - you may for example use Microsoft Excel's graphs, formatting, forms, formulas and other Excel specific features. * Print out parent-child tree-like layout.
It is not possible to print Datasheet with Subdatasheet or Form with Subform and the underlying data of both the parent and children levels all at once directly from Access.
Nevertheless after you export parent-child tree-like organized data into Excel you may print it now from there easily. * Export 1:N structured data into many other file formats (htm, pdf, csv,...)
- Send selected database data via Email, Reduce file size
* And many more
Tool's advantages are:
- It can be run without installation.
- Uniqueness (no other tool can do this).
- Broad compatibility (It is compatible with Microsoft Office versions from 2002 to 2016 and 365).
- Range of customizations.
Version 8.7: After I discontinued the development and removed this tool from Internet couple of years ago, too many people have - to my surprise - asked me to publish it again. So here it is. I just made it compatible with all new versions of Microsoft Office. Enjoy!
Version 8.6: After I discontinued the development and removed this tool from Internet couple of years ago, many people have - to my surprise - asked me to restore it. So now it is here again. There are no new functions. I just made it compatible with new versions of Office. Enjoy!
Version 8.5: After I discontinued the development and removed this tool from Internet couple of years ago, many people have - to my surprise - asked me for it. So I decided to re-publish it. There are no new functions. The only new thing is that the tool is available again! I hope this will help you.