In the corporate environment, Excel is king. So when you have an Access database report that you would really prefer to analyze in Excel spreadsheet form, there’s an easy way to convert it.
To convert it, start by opening up your Access Report in Print Preview mode.
Make sure you have the Print Preview Toolbar showing. You just need to right click an empty area on your toolbar and select “Customize” and check the toolbar.
From the Print Preview Taskbar click the drop down menu and select “Analyze It with Microsoft Office Excel”.
Your Report will now be in Excel for you to change and analyze the data.
Programmer by day, geek by night, The Geek, also known as Lowell Heddings, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on Google+ if you'd like.
- Published 05/16/07