![]() To automatically open the report in Access after you export the report, select the Show application after exporting check box. The options for exporting the report to Access are displayed. Select MS Access Database from the Application drop-down menu. If you want to configure export options, complete the following steps:įrom the Data menu, choose Export Options. (For steps to run a report, see Running a report.) ![]() In Access, import the Excel spreadsheet as external data. For example, you can export the file to Excel and save it. To select which report elements to export, you can choose a different export format, update the export options, export the file, and then convert it to an Access database. ![]() Exporting a report to a Microsoft Access databaseįor a report exported to an Access database, you cannot change which report elements (such as title, details, data, headers, and SQL) are exported or whether the report formatting is exported (the options available on the Export Options: Appearance tab). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |