Garry Robinson's Popular MS Access, Office and VB Resource Site


Home  Contact Us

Order Software

Search vb123

 Smart Access  
The Magazine that Access Developers loved to read and write for is back
Article Index Here or
Purchase Here

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Sign up here

Get Good Help
If you need help with a database, our Australian Professionals could be the answer
Read More

123 For Office

Great shortcuts, supports Office 2013 to 2003, easy zipping.
Read More

  The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and zip backups, change startup options,  compile, shutdown database
Read and Download

Access > SqlServer 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

Like FMS Products?
Purchase them from us and get a free Workbench or Smart Access  More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...



Next Tip  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)

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

If you need to send the results of a query to an associate, click on Menu

File    Send 

and choose Excel as the export option.  This will send the query/table by email looking the same as figure 4.  You can even choose Selection and only send the cells that you have selected by email.


These tips were provided to you by Garry Robinson - Software Consultant based in Sydney, Australia. Try out our popular Access shareware Graf-FX   http://www.vb123.com/graf/

Published  1999-

Other related pages

Indexing Tables Tips For Microsoft Access (Next Page)
Single Precision

Access Data Entry Tips

Using Access Filters to Graph and Explore Your Databases

Automate Your Email Using Access and Exchange-Outlook




Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals