Note:В You can't export a portion of a report. For instructions, go to Open an object in the Datasheet View. If the object is a table, query, or form, and you want to export only a portion of the data, open the object in the Datasheet View and select the records you want. Navigate to the source database, and select the object that you want to export. If you have a destination Excel workbook ready, close it. The data is always added to a new worksheet.ДЄccess doesn't currently support exporting macros or modules to Excel. If you don't have a workbook ready, it will be created during the export. However, you can merge multiple worksheets in Excel after you complete the individual export operations. You can only export one database object in a single export operation. You must repeat the export operation for each subform, subreport, and subdatasheet that you want to export to Excel. When you export a form, report, or datasheet that contains subforms, subreports, or subdatasheets, only the main form, report, or datasheet is exported. Note:В Reports can only be exported in the older *.xls file format, not in the newer *.xlsx file format. If you export a table, query, form, or report with formatting to an existing workbook, the workbook will be overwritten. For more information on the outcome of exporting formatted and unformatted data, go to section Prepare for the export operation in Export data to Excel.Д¬hoose the destination workbook and file format. This decision affects the amount of data that is exported and the display format of the data. For troubleshooting info, go to the section Troubleshoot missing and incorrect values in Export data to Excel.Дecide whether you want to export a table or query with or without its formatting. Otherwise, problems can occur during the export, and null values might be inserted into Excel worksheet cells. Make sure the data doesn't contain any error indicators or error values. To learn more about screen readers, go to How screen readers work with Microsoft Office.Д«efore exporting your data, take a moment to review the data and decide how you want to export it. To learn how you can get new features faster, join the Office Insider program. New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet.

Extract data viewer