Saturday, December 10, 2011

How To Share MS Access Data With MS Excel

Sometimes we may need data from other applications which will be in different format and we may have to copy, edit and remake the data. In those instances sharing the entire file might help in reducing the time of copying and editing it. We can share Access data with other applications easily in Office 2010. We will see how can we share it with Excel 2010.

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.

 It will now ask us to select the excel file from the disk.
 It will ask to save the Export Steps to make it easier for 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 it is needed and repeated regularly.  


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


Source:-http://msofficesupport.blogspot.com/2011/04/share-ms-access-data-with-ms-excel.html

Related Post:-
How to Fix the Runtime Error
How to Fix Error Code 0x8007232b for Windows 7
How To Take Screenshots from Word, Excel, PowerPoint inbuilt Tool

1 comments:

Thanks for the post. Here’s how you can move or convert Microsoft Access to web in minutes http://www.caspio.com/extend/platform-extensions/ms-access-database-online/convert-ms-access-to-web.aspx

Post a Comment