Access includes a tool to export data from an Access database structure to an Excel spreadsheet.
Start Access. Open the Access file Dept_Data.mdb from the folder that contains your project files. A database window displays.
In the database window, on the Objects list, click Queries to review the list of query objects.
Double-click the Weekly Salary Query to display the selected data.
On the File menu, click Export.
In the Export dialog box, navigate to the folder that contains your project files, and then in the File name box, type Meeting_Data_Firstname_Lastname
In the Save as type list, click Microsoft Excel 97 2003.
Click the Export All button. This saves all the data from the Access query as a new Excel file.
Close the Query window, and leave Access open for use later.
GO! with Microsoft Office 2003 Brief (2nd Edition)