Sending Microsoft Access Data to Microsoft Excel/Microsoft Word
There are two relatively simple ways to send formatted data from Microsoft Access to Microsoft Excel/Word:
- You can highlight the data you want transferred and use the standard Copy/Paste commands on these application's Edit menus
- You can use Output to on the File menu to save the output of a table, query, form, report or module to a file in one of the following formats: Microsoft Excel (.XLS), Rich Text Format (.RTF) or MS-DOS Text (.TXT)
As an alternative to this command, you can use Access to ... toolbar buttons to save the data to a file in the Microsoft Access working directory and immediately start the appropriate application.