If you’re a data administrator in Office 2010, you know that sharing access to data with Excel is a key part of managing your office’s data. In this article, we’ll show you how to share access to data with Excel in Office 2010 using the Share button on the ribbon. When you share access to data with Excel, you’re giving other users the ability to see and use your office’s data. This can be a great way for team members to collaborate on projects, or for users who need more control over their office’s data. To share access to data with Excel in Office 2010, follow these steps:
- On the ribbon, click the Share button. This will open a dialog box that looks like Figure 1. Figure 1: The Share button on the ribbon in Office 2010 lets other users see and use your office’s data.
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.
A window comes up asking where to save the file, the file format, and some other exporting options.
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.
The data goes into Excel and 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 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.
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
