- 1). Open Microsoft Access. Select "Object Type" in the navigation pane.
- 2). Go to the "Queries" section and double-click the query you want to copy. It's loaded in Access. To switch to "Datasheet View," select the "Home" tab. Choose "View" and "Datasheet View" from the "View" group.
- 3). Highlight the data you want to copy in the query. To highlight the entire query, click the "Select All" button to the left of the first column header.
- 4). Go to the "Home" tab and select "Copy" from the "Clipboard" group, or press "Ctrl+C" to copy the data.
- 5). Open the spreadsheet or document where you want to use the data. To place the data in another query, find and double-click the query in Access and switch to "Datasheet View" (see step two).
- 6). Navigate to the cell or area where the data will go and press "Ctrl+V" to paste the query there.