Here's a quick and easy trick for getting your Access report data into Excel - organized just the way you want.
Let's say you distribute a Customer report (Figure A) to all management personnel every month. Now, they would like you to send them the same report, including the City groupings, as an Excel worksheet.
Unlike other Access Import tools, Access 2002/2003's Office Links tool can do just that. (Note: This feature is not available in Access 2007.) Follow these steps:
- Open the Access database that contains the Customer report.
- Click Report under Objects in the Database Window and select Customer Report By City.
- Go to Tools | Office Links and click Analyze It With Microsoft Excel (Figure B).
Access opens a new Excel workbook with the data arranged in columns exactly as the original report, including grouping the data by the City field (Figure C).
Miss an Access tip?
Check out the Microsoft Access archive and catch up on other Access tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.