Export an Access 2003 report into Excel is a great way to keep track of your data and analyze it in a more organized way. By exporting your report into Excel, you can easily create graphs, charts, and tables to help you understand your data. ..
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.
