Helpdesk Baruch College

Share Access Data with Excel in Office 2010

Being able to share Access information with various other applications is less complicated in Office 2010. Today we have a look at how easy it is to share information from an Access 2010 Database to an Excel spreadsheet and even more.

Share Access Data

Initially we’ll take a look at sharing an Access table to an Excel spread sheet. Open up the Access table you wish to export as well as click the External Data tab. From below you can see a lot of various choices you have for exporting the information. In this instance we’re using exporting to Excel so click on that.

A window shows up asking where to conserve the documents, the documents layout, and also some other exporting choices.

In the following display you could intend to conserve the Export Steps to make it easier the next time or if you’re collaborating with a number of files and also need to do the very same thing. From right here you can additionally set up an Outlook task if you consistently need to repeat it.

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

There are a lot of other applications Access 2010 will certainly allow you export data, like text files, Word, a SharePoint List as well as even more. There is a very easy Word Merge function so if you have a database of addresses you can quickly include it with Mail Merge.

In some cases getting the data you need out of an Access Database can be a little bit difficult. It appears like these tasks will certainly be a great deal simpler in Office 2010, which will be fantastic for boosting productivity.

Try the Office 2010 Beta

Exit mobile version
Skip to toolbar