Getting Data From Access Into Excel    

<< Click to Display Table of Contents >>

Navigation:  Word, Outlook, Excel and Dropbox >

Getting Data From Access Into Excel    

 

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)

 

exceltransfer1

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.

exceltransfer2

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

exceltransfer3

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.

exceltransfer4

Figure 4 - Pasting selection into Excel