Export an Access 2003 Report Into Excel Spreadsheet

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.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+