This tool enables exporting of following Microsoft Access structures / objects into Microsoft Excel: - Table with subdatasheet - Query with subdatasheet - Form in datasheet view with subdatasheet - Form with subform It may also be 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 levels (Subdatasheets or Subforms) get exported into MS Excel worksheet while keeping the original Access-like drill-down view. It is 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 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 analyse 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 No installation is required.
VERSION HISTORY
- Version 8.5 posted on 2015-09-24
Few minor bugs fixed. - Version 7.2 posted on 2014-06-01
The stability of the tool was increased and user interface enhanced.
Program Details
- Category: Business > Databases & Tools
- Publisher: Norbert Limbersky
- License: Free Trial
- Price: $9.00
- Version: 8.5
- Platform: windows