Garry Robinson's Popular MS Access, Office and VB
The Magazine that Access Developers loved to read and write for is back
Article Index Here or
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
Great shortcuts, supports Office
2013 to 2003, easy zipping.
Find out who has
your database open, start the correct version of Access, easy compacting
and zip backups, change startup options, compile, shutdown
Access > SqlServer
Upsize to SQL Server 2005 or 2008, easily repeated conversions,
highly accurate SQL query
translation and web form conversion.
Like FMS Products?
Purchase them from us and get a free Workbench or Smart Access
Find out a few other things that
Garry has been writing about Microsoft Access.
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
Contact Us ...
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
Apply any filters that you want
Click in the top left hand corner of the grid
Control C (Copy)
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
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
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
Other related pages
Indexing Tables Tips For Microsoft
Access (Next Page)
Access Data Entry Tips
Using Access Filters to Graph and Explore Your Databases
Automate Your Email Using Access and Exchange-Outlook