Exporting forms, reports, or datasheets that contain subforms, subreports, and subdatasheets, only the main form, report, or datasheet is exported. How to export data from Access to Excel ...

We show you how to import data from Access Data Database into Micrsoft Excel. Access is the primary tool for managing a database.

This pane displays a list of macro categories. Move to the Action Catalog Pane and double-click "Data Import/Export" to view the macros within that category. The ImportExportSpreadsheet form appears.