Word, Outlook, Excel and Dropbox > Getting Data From Access Into Excel

Navigation:  Word, Outlook, Excel and Dropbox >

Getting Data From Access Into Excel  

Previous pageReturn to chapter overviewNext page


Here are a few steps that you can follow to transfer data easily from Access to Excel  (see Figure 1)

Open the table/query/form that you want to transfer
Apply any filters that you want
Click in the top left hand corner of the grid
Control C  (Copy)
Open Excel
Control V  (Paste)



Figure 1 - Selecting the full data set to copy

If you want to be more specific about what you transfer to Excel, you can click on the record selectors as show in figure 2 and hold the mouse down until you have all the consecutive rows that that you need.  Then Copy and Paste to Excel as before.


Figure 2 - Selecting rows to copy

And finally there is a really obscure trick where you can actually select the cells inside the grid by hovering your mouse on the corner of a grid cell until a cross comes up for the mouse pointer (Figure 3).  Then click the mouse and hold down and drag to select the cells that you want.  Copy and Paste as before


Figure 3 - Selecting Cells to Copy

Finally when you transfer to Excel, the final outcome looks like figure 4.  You can also use this transfer method to copy to FrontPage, Word and other aware programs.


Figure 4 - Pasting selection into Excel