The Database Journal
03/10/2006
Adjusting Autonumber Increments

03/10/2006
Moving Access Data to Microsoft Excel

03/10/2006
Exporting Access Data with TransferSpreadsheet

03/10/2006
Export Access Data with VBA

03/13/2006
Data Layout in Microsoft Excel

03/17/2006
Excel Text to Number Conversion

03/21/2006
Transposing Excel Ranges

03/25/2006
Access VBA Timer Event

03/29/2006
What is MySQL?

04/02/2006
Microsoft Access Parameter Query Tutorial Video

04/06/2006
How does PHP Work?

04/10/2006
Microsoft Access VBA Tools - References

Click here to view all articles.

Database Design
Website Design
Search Engine Marketing
Home
Contact Us
About Us
Database Journal
Newsletters
Database Newsletter

Moving Access Data to Microsoft Excel

Microsoft Access has some built-in ways to move data from Access to other Office Applications and it comes in the form of a simple little menu option that people too often forget about.

Open up any query in a database (for the purposes of not crashing your machine – try to make it a standard select query and a small one at that, or put on some criteria so you don’t have a gazillion records ready to be shifted about). While looking at the query in datasheet view, click on “Tools”, then “Office Links”, and then “Analyze It with Microsoft Excel” (see Figure 1).

Figure 1

All of a sudden, just mere moments later, bingo! You’ve got your data in a nice and comfy Excel Workbook ready to analyze. This is probably the easiest Microsoft Access export you'll ever have the pleasure of doing!

Now if you opt to move the data into Microsoft Word with the “Publish It with Microsoft Word” option, you may encounter some formatting issues if you have a large number of columns in the query or some of your data happens to be larger. While this isn’t a big issue if you don’t mind doing a little Word Table formatting – many times that’s just not a preferred way to spend an afternoon.

The “Merge It with Microsoft Word” option you see here in my screenshot of Access XP simply takes your data and dumps it into an existing Mail Merge Main Document or allows you to create one. If you have a form letter that you’ll be addressing to a few hundred people you have stored in a database, this is a great option to get all of the letters made with every piece of specific information in place (ie: Each letter will be personalized). Mail Merges open up an entirely different world of possibilities that we won’t cover right now – just know that it’s there and ready to be used!

Really, this “easy” method of moving data out of Access should cover about 90% of everything you’ll ever need to do. Most often, it’s about getting data from point A to point B and since Access does it for you easily, there’s pretty much no real drawback unless you need a little customization – or something a little different.


©2014 Blue Moose Technology, LLC

David Badurina, President of Blue Moose Technology, LLC, is a relational database design expert. David's unique ability to easily explain virtually any technical concept has allowed him to work with companies such as AMD, Motorola, the American Heart Association, and countless small businesses. Learn more about database design right now at http://www.bluemoosetech.com.

Article Publishing and Re-Print Guidelines

You can easily link to this article!

If you'd like to link to this article from your own website, copy and paste the following HTML code onto your page:

On your page, the code will appear like this:

Moving Access Data to Microsoft Excel