Microsoft Access - Quickly Copy Data to Other Office Applications (Access 97/2000/2002)

If you want to display data from Access in another Office application, there are a number of ways to approach the task. However, one of the easiest may not be obvious. When you need to copy an entire table or query recordset, simply drag the appropriate object icon from the Database window to the Office document with which you're working. Using this approach with Word or PowerPoint creates a table and using it with Excel populates a range appropriately.

The technique even works with parameter queries. After you drag and drop the object icon, you're prompted for the parameters as usual. Once you answer the parameter prompts, the results are inserted into the destination document.

Go back