SEARCH

How-To Geek

Share Access Data with Excel in Office 2010

Being able to share Access data with other applications is easier in Office 2010. Today we take a look at how easy it is to share data from an Access 2010 Database to to an Excel spreadsheet and more.

Share Access Data

First we’ll take a look at sharing an Access table to an Excel spreadsheet. Open the Access table you want to export and click on the External Data tab. From here you can see a bunch of different options you have for exporting the data. In this example we’re using exporting to Excel so click on that.

2 exp

A window comes up asking where to save the file, the file format, and some other exporting options.

3 exp

In the next screen you might want to save the Export Steps to make it easier the next time or if you’re working with several documents and need to do the same thing. From here you can also set up an Outlook task if you regularly need to repeat it.

4 exp

The data goes into Excel and you can start working on it here, or send it where it needs to go.

5 exp

There are a lot of other applications Access 2010 will let you export data, like text files, Word, a SharePoint List and more. There is an easy Word Merge feature so if you have a database of addresses you can easily incorporate it with Mail Merge.

6 exp

Sometimes getting the data you need out of an Access Database can be a bit daunting. It looks like these tasks will be a lot easier in Office 2010, which will be great for increasing productivity.

Try the Office 2010 Beta

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 01/28/10

Comments (2)

  1. james alcaraz

    if export is all you need (w/o linking), then it’d be a lot easier to

    1. Select all (click upper-left corner of the table).
    2. Ctrl-C then go to excel and paste.

    Of course your method is more efficient if your data is gigantic. But on small tables copy and paste should be easier.

  2. Bets Strohl

    I used to be able to send (email) the results of a query. It was about a two click process. Now that is gone. Any suggestions?

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!